Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

select only the first row in a group

Status
Not open for further replies.

wbooster

Computer
Feb 4, 2007
2
0
0
TW
If I have data

a 1
a 2
a 3
b 3
b 2
c 1
c 2
d 2

I only want to select a, b, c, and d's first record.like
a 1
b 1
c 3
d 2

how do I do it
 
Status
Not open for further replies.
Back
Top