Skip to main content
Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.

Nav

Member since May 14, 2014

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 »