ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vincent NICOLAS <vincent.nico...@teamlog.com>
Subject Re: [OT] Need help with SQL Query
Date Mon, 27 Feb 2006 08:14:55 GMT
Maybe the "having" clause :
select date, time, name from mytable
having date = min(date)

Ashish Kulkarni a écrit :
> 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
>
>   


-- 
Vincent NICOLAS
Teamlog, Lyon


Mime
View raw message