A little hasty with my answer...
The query I gave could give you results from two different rows.
Having a date and time column is problematic. I would just use a
date column that included the time or a timestamp.
If there is only one column to worry about then you could do
select date, name from mytable where number = 123 and date = (select
min(date) from mytable where number = 123)
nathan
On Feb 24, 2006, at 9:25 AM, Nathan Maves wrote:
You almost had it :)
select min(date), min(time), name from mytable where number = 123
group by name
Nathan
On Feb 24, 2006, at 8:58 AM, Ashish Kulkarni wrote:
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
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
