ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ashish Kulkarni <kulkarni_ash1...@yahoo.com>
Subject [OT] Need help with SQL Query
Date Fri, 24 Feb 2006 15:58:16 GMT
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
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
wont work


Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 

View raw message