I dunno if labeled this correctly but here's the question:
I have 1 table containing people and their job titles.
Some people have more than 1 title.
I want to select a distinct list of people and only show the first title they appear with.
id emp_num name
1 111 Bob
2 111 Bob &
View Complete Post