select the rows for names with the lowest date/time (per name):
select date, time, name from mytable A
having timestamp(date, time) = select min(timestamp(date, time))
from mytable B
where A.name = B.name
Regards,
Sven
>----- Oorspronkelijk bericht -----
>Van: Vincent NICOLAS [mailto:[EMAIL PROTECTED]
>Verzonden: maandag, februari 27, 2006 09:14 AM
>Aan: [email protected]
>Onderwerp: Re: [OT] Need help with SQL Query
>
>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
>
>
