Re: Need some SQL help

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