How to take first 4 time for each person.
Posted
by Gopal
on Stack Overflow
See other posts from Stack Overflow
or by Gopal
Published on 2010-03-16T07:22:30Z
Indexed on
2010/03/16
7:26 UTC
Read the original article
Hit count: 285
Filed under:
ms-access
|ms-access-2007
Using Access Database
Table
ID Time
001 100000
001 100005
001 103000
001 102500
001 110000
001 120000
001 113000
...,
From the above table, i want to take first four time
Query like
Select id, min(time) from table group by id
I want to take first four min(time) for each person
Expected Output
ID Time
001 100000
001 100005
001 102500
001 103000
002
...,
How to make a query for this condition?
© Stack Overflow or respective owner
