Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations SDETERS on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

select only the first row in a group

Status
Not open for further replies.

wbooster

Computer
Feb 4, 2007
2
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.

Part and Inventory Search

Sponsor