Query with Timestamp and aggregate Function [message #361960] |
Fri, 28 November 2008 15:37  |
bandsb
Messages: 1 Registered: November 2008
|
Junior Member |
|
|
I want to get the users who logged in each hour of the day
In my table i have the column called created_at, there i am storing timestamp,
I need a query to retrieve the data like
Time count
1-2 44
2-3 35
3-4 126
upto
23-24 410
How can i get the data in this format using SQL Query .
I would appreciate if any one help me out , i am newbie to Oracle
[Updated on: Fri, 28 November 2008 23:40] Report message to a moderator
|
|
|
|
|