wouldn't that be: select date, time name from mytable where number = 123 order by date desc, time ASCEND FETCH first row only For min date, time?? Thanks, Tommy Holden -----Original Message----- From: java400-l-bounces+tommy.holden=hcahealthcare.com@xxxxxxxxxxxx [mailto:java400-l-bounces+tommy.holden=hcahealthcare.com@xxxxxxxxxxxx] On Behalf Of Alex Pinsky Sent: Friday, February 24, 2006 10:12 AM To: Java Programming on and around the iSeries / AS400 Subject: RE: [OT] Need help with SQL Query Hi Ashish, try this: select date, time name from mytable where number = 123 order by date desc, time desc FETCH first row only Regards, Alex Pinsky Aeropostale, Inc. -----Original Message----- From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx]On Behalf Of Ashish Kulkarni Sent: Friday, February 24, 2006 10:57 AM To: java400-l@xxxxxxxxxxxx Subject: [OT] Need help with SQL Query Hi I have a table with 4 columns number, name, date, time, it is not unique so can have multiple entries for one name at different date and time. I need to find out the first instance of name for that number in this table, or get the name with minimum date and time i can do select min(date), min(time) from mytable where number=123 this will give me the min date and time , but how can i get the name also, for example select min(date), min(time), name from mytable number=123 wont work Ashish A$HI$H __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.