I am trying to create a query that will do two parallel select from the data available. I want to write one select statement using analytical functions, What I want to do is as follows:
I one single query I want to find out the count of the transactions in the last 7 days from sysdate and last 6 months from sysdate. The table has got transactions and the corresponding dates.
I am new with the analytical functions and finding it difficult to understand the use of the 'order' and 'range' options. It will be great if someone can write the above query with an explanation how it works.
October 16, 2005 7:16 PM
October 28, 2005 9:06 AM