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
