Eng-Tips is the largest engineering community on the Internet
Intelligent Work Forums for Engineering Professionals
-
Congratulations waross 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
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 3 c 1 d 2 how do I do it -
select only the first row in a group
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
