Hi I used the following sql statement to get it working select date, time, name from mytable number=123 order by date, time FETCH FIRST 1 ROWS ONLY
--- Nathan Maves <[EMAIL PROTECTED]> wrote: > 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 > > > > A$HI$H __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
