|
Posted by jsfromynr on 10/02/78 11:56
Hi Skip,
You may like to try this
Select * from YourTable A
Where Not Exists(Select 1 from YourTable B where A.hole_id=B.hole_id
and A.date_time>B.date_time)
Returning those rows of hole_id which have only max date_time.
I hope this helps
With Warm regards
Jatinder Singh
http://jatindersingh.blogspot.com
http://sqloracle.tripod.com
Navigation:
[Reply to this message]
|