April 24, 2009 at 8:03 am
Hi I need some help in writing the query
ID DATEBEN
19391227200412011
193912272004120123
193912272004120124
193912272009070122
193933272004120122
1939332720041201224
193933272004120122
193933272009080122
There are 3 columns and ID ,date and Ben.I want to select only those IDs with recent DATE ...for example in the ID 19391227 the recent date is 20090701.....Help me in writing this logic....
Thanks
Sudheer
April 24, 2009 at 8:20 am
Please don't double-post in multiple forums with the same question.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy