Post reply

Need help in writing query

  • April 24, 2009 at 8:03 am

    #130282

    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

    #983567

    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