Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sql query for summary daily or per hour

Hans MüllerFeb 14 2017 — edited Feb 14 2017

Hi,

sql below i get the data of last week (15000 rows),

select ENQUEUED_AT from REQUESTTABLE where ID=326  and enqueued_at >= sysdate -7 order by 1;

Results:

07.02.17 20:37:39,767000000

07.02.17 20:38:06,952000000

07.02.17 20:38:46,346000000

07.02.17 20:38:47,468000000

.....

.....

i want to know how many rows per hour and per day?? for the last 7 days

thanx
This post has been answered by Solomon Yakobson on Feb 14 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 14 2017
Added on Feb 14 2017
3 comments
753 views