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...
