-
It seems simple, but I need some help to write a query that will only select the first row (columns a,b,c,d,e) of a group of similar rows. Example: an employee can have one or more records (columns a is the employee number), but I only want to extract the first row for each employee. See below:
Table
Emp, Fname, Lname,itemNo, ItemDesc
1 joe smith 123 test part
1 joe smith 134 test part 2
1 joe smith 145 test part 3
2 bill white 111 partb
3 dave green 123 test part
3 dave green 111 partb
These are the rows I'm trying to extract:
1 joe smith 123 test part
2 bill white 111 partb
3 dave green 111 partb
Please help. Thanks!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|