Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ketangarg86
Starting Member
3 Posts |
 Posted - 2015-03-12 : 11:14:23
|
| Hi,I have a requirement to calculate the % change in the number of orders received today with the number of orders that were received 3 days back. All data is in the same table. There is a received date column.I have two count(*) queries - one for today and one for 3 days back running separately and getting the results. Is it possible I can get the % change in orders received from 3 days back and today in one query.Also if I want to get the number of orders received today between 12:00am today and current time. How would I modify the query.Please help. I am relatively new to Oracle SQL.ThanksKetan |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-03-12 : 11:20:11
|
| This is a SQL Server forum. You should probably ask your question in an Oracle forum |
 |
|
|
ketangarg86
Starting Member
3 Posts |
Posted - 2015-03-12 : 11:24:23
|
| Will do. Thanks. |
|
|
|
|
|
|
Two count sql queries