Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-16 : 14:51:17
|
Henry writes "
A simple table logs the date/time that each user uses some system each time. So the table may look like this:
'john', '4/22/00 20:22:51'
'mary', '8/13/00 12:22:23'
'john', '2/12/00 20:22:41'
'tom', '1/03/00 16:32:26'
'john', '3/12/00 21:25:51'
'mary', '1/16/00 12:22:15'
'tom', '6/12/00 20:32:28'
'mary', '8/13/00 12:22:31'
I want to find out the first use for each user using, preferably,
a single query:
'john', '3/12/00 21:25:51'
'mary', '1/16/00 12:22:15'
'tom', '1/03/00 16:32:26'
Thanks." |
|
|
|
|
|
find the first use for each user