SQL select one from each group

Asked Jun 02 '16 at 09:53

Active Jun 02 '16 at 09:57

Viewed 27 times

Assume this table,

id  name   class
---+-----+------
 1     a    rare 
 2     a  common
 3     b  common 
 4     b  common

and we group rows by name. How to select from each group the only rare row if exists or else (if rare does not occur in the grouping) the first common row, so that we get

id  name   class
---+-----+------
 1     a    rare 
 3     b  common

edited Jun 02 '16 at 09:56

asked Jun 02 '16 at 09:53

echo

1,241
1
13
16

1

Which database you are using? – Sandeep Poonia Jun 02 '16 at 09:55
mysql, thanks edited tags. – echo Jun 02 '16 at 09:56
See here http://sqlfiddle.com/#!9/c7fe4/4 – juergen d Jun 02 '16 at 10:28

SQL select one from each group

0 Answers0