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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!