On Sun, 6 Oct 2002, Brian Ward wrote: > I have a table > id int > status int > create_dt datetime > > When users log in and out I insert a row into this table throughout the day. > I'm trying though to come up with a querie to tell me and ordering of users > as they report in in the morning so i'm trying to say > select each user and the earliest time the logged in in a give day, then > order that by the create_dt column. > > Having trouble writing the SQL though
select * from table order by id, create_dt If you want this information only for a specific date, when add in a where clause : where create_dt GT 'some date' Change Gt to the greater than character, which isn't working on this keyboard... ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
