Home » SQL & PL/SQL » SQL & PL/SQL » SQL Query
SQL Query [message #221268] Mon, 26 February 2007 01:25 Go to next message
Messages: 48
Registered: February 2007
hi all
i have attached an excel sheet containing data of time_dim table.from this table i want to extract last 13 weeks of data depending on week_code.i want to pass sysdate as a parameter and want to extract last 13 weeks of data i.e. last 13 week_code data.
please hep me writing this query
  • Attachment: time_dim.xls
    (Size: 154.04KB, Downloaded 450 times)
Re: SQL Query [message #221367 is a reply to message #221268] Mon, 26 February 2007 08:17 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
It is an observed phenomenon that questions that involve attachments get less answers than those where the OP can clearly and concisely state his conditions in the message.
Also, many people (myself included) don't go round opening 3rd party attachments, particulary those that have a reputation for macro viruses.

Previous Topic: Why optimizer select plan with higher cost?
Next Topic: Check Constraints
Goto Forum:

Current Time: Fri Aug 18 03:33:39 CDT 2017

Total time taken to generate the page: 0.08074 seconds