Help with Query! Need to filter large table to 10 records per # in Employee Field

[nbrock2002]

ID	EMPTY	EMPLOYEE	AREA_DESCR	LOCATION_D	SKU	DESCRIPTIO	EXTENDED_Q	STORE_PRIC	EXTENDED_P
15668		1061	SIDE 6B	6B PIZZA/MICRO 3'	01330051501		11.00	0.79	8.69
15669		1061	SIDE 6B	6B PIZZA/MICRO 3'	01600030200		6.00	0.99	5.94
15670		1061	SIDE 6B	6B PIZZA/MICRO 3'	02100004254		6.00	2.99	17.94
15671		1061	SIDE 6B	6B PIZZA/MICRO 3'	02100004255		3.00	2.99	8.97
15672		1061	SIDE 6B	6B PIZZA/MICRO 3'	02100004329		8.00	2.99	23.92
15673		1061	SIDE 6B	6B PIZZA/MICRO 3'	02100005259		7.00	2.99	20.93
15674		1061	SIDE 6B	6B PIZZA/MICRO 3'	02400034606		18.00	0.65	11.70
15675		1061	SIDE 6B	6B PIZZA/MICRO 3'	02400034616		12.00	1.69	20.28
15676		1061	SIDE 6B	6B PIZZA/MICRO 3'	02400034776		16.00	1.25	20.00
15677		1061	SIDE 6B	6B PIZZA/MICRO 3'	03620000550		7.00	1.49	10.43
15678		1061	SIDE 6B	6B PIZZA/MICRO 3'	03620000580		8.00	1.99	15.92

[CJ_London]

use a subquery - something like

SELECT *
FROM myTable
WHERE ID in (SELECT top 10 ID from myTable T WHERE Employee=myTable.Employee)

You can add ordering to the subquery to return the latest/earliest whatever

[ssanfu]

Duplicate question.......
https://www.accessforums.net/showthread.php?t=68220