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!

To fetch records on hourly basis

743195Jan 1 2010 — edited Jan 1 2010
The requiremnt is:

Table A has field LastUpdatedate.
I need to determine the records processed in each hour starting from Min(Lastupdatedate) till Max(LastUpdateDate)

Is there a way to find out the above in a single query?

Only count in result set will do.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 29 2010
Added on Jan 1 2010
#oracle
1 comment
1,959 views