RSS

Select max date, then max time for that date?

Please support our Oracle advertiser: Programming Forums

Thread Tools Display Modes

Views: 2611 | Replies: 3

•

Previous Post in Thread

Next Post in Thread

•

Join Date: May 2008

Posts: 33

Reputation: 2eXtreme is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

2eXtreme

Offline

Light Poster

Select max date, then max time for that date?

Jul 3rd, 2008

Hey guys

I have a table, that lists people, with a correpsonding date and time for each activity. My structure is like:

PersonID......Date............Time
872367.........01/01/08......15:00:00
872367.........01/01/08......16:00:00
872367.........01/01/08......18:00:00
976737.........01/01/08......19:00:00
976737.........02/01/08......16:00:00
911967.........03/01/08......18:00:00

I want to have a query that returns each persons latest activity date and time, so I want a table like:

PersonID......Date............Time
872367.........01/01/08......18:00:00
976737.........02/01/08......16:00:00
911967.........03/01/08......18:00:00

I tried something like

Help with Code Tags

(Toggle Plain Text)

select PersonID, max(Date), max(Time)
from myTable
group by PersonID

This returned the

PersonID, latest activity date for that person, but not the latest time for that date, just the latest time for that person, if that makes sense?

So I got something like:

PersonID......Date............Time
872367.........01/01/08......18:00:00
976737.........02/01/08......19:00:00
911967.........03/01/08......18:00:00

Notice how the second row of data has the max date for that person, and the max time for that person - I need the max date for that person, and the max time for that date

Thanks for any help!