title: SQL how to display the value that appears more than once just once
body: <p>Example: If I have a table called "list" and have more columns like (id, game and genre) and I want to display a list of all the genres that games have and if a genre appears more than once I want to display it just once. (Need the SQL code) I've tried with <code>COUNT</code> but it doesn't work.</p>
  
  <p>Example Table list:</p>
  
  <p><a href="https://i.stack.imgur.com/IQPwA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/IQPwA.png" alt="enter image description here"></a></p>