RE: [OT] Need help with SQL Query

Hi
Thanx guys, it works 

--- Alex Pinsky <apinsky@xxxxxxxxxxxxxxx> wrote:

> 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 
> -- 
> This is the Java Programming on and around the
> iSeries / AS400
> (JAVA400-L) mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/java400-l.
> 
> 
> 
> CONFIDENTIALITY NOTE: The information contained in
> this email or fax is 
> intended only for the use of the individual or
> entity to whom it is
> addressed.
> If you are not the intended recipient, you are
> hereby notified that any 
> disclosure, copying, distribution, printing or other
> use of, or any
> action 
> taken in reliance upon, the contents of this email
> or fax and the
> information
> contained therein is strictly prohibited. Before
> opening or using
> attachments, 
> check them for viruses and defects.  Our liability
> to you for viruses or
> 
> defects associated with any email or fax is strictly
> limited to
> resupplying any 
> affected attachments.  If you have received this
> communication in error,
> please immediately notify the sender by telephone at
> (646) 485-5398 and 
> delete the original message. Thank you.
> 
> 
> -- 
> This is the Java Programming on and around the
> iSeries / AS400
> (JAVA400-L) mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/java400-l.
> 
> 
> -- 
> This is the Java Programming on and around the
> iSeries / AS400 (JAVA400-L) mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/java400-l.
> 
> 
> 
> -- 
> This is the Java Programming on and around the
> iSeries / AS400 (JAVA400-L) mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/java400-l.
> 
> 


A$HI$H

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com