Need some SQL help - Mailing list pgsql-sql

From Brian Ward
Subject Need some SQL help
Date
Msg-id anplc4$3ci$1@news.hub.org
Whole thread Raw
Responses Re: Need some SQL help
List pgsql-sql
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




pgsql-sql by date:

Previous
From: "Brian Ward"
Date:
Subject: Re: timestamp
Next
From: "scott.marlowe"
Date:
Subject: Re: [GENERAL] arrays