yes, you are correct

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx]On Behalf Of Holden Tommy
Sent: Friday, February 24, 2006 11:07 AM
To: Java Programming on and around the iSeries / AS400
Subject: RE: [OT] Need help with SQL Query


 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.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.