Nav
Member since May 14, 2014
- Profile: /members/11917-nav.htm
- Comments: 1
Recent Blog Comments By Nav
-
Getting One Record Per Group From A One-to-Many Join
Posted on May 14, 2014 at 2:23 PM
Here is a different and more efficient way to do this (from StackOverflow post referenced below (I have not added the additional select * with the appropriate where clause)): Example: user1 CategoryA 10 user2 CategoryA 11 user3 CategoryA 9 user4 CategoryB 3 user1 CategoryB 11 the query ... read more »