sql group by the in statement code example Example: select query group by name SELECT `gender` FROM `members` GROUP BY `gender`;