title: SQL select only rows which have same column value
body: <p>I need some hints.. I got a table which looks like that: </p>
  
  <pre><code>id  fruit   delicious
  1   apple   1
  2   apple   0
  3   apple   1
  4   cherry  1
  5   cherry  1
  6   cherry  1
  7   banana  0
  8   banana  0
  9   banana  0
  </code></pre>
  
  <p>For this table I want to create a statement which will only return the fruits which are 
  completely delicious but not the fruits which are partially delicious. 
  In this example only "cherry" should be returned. </p>
  
  <p>Currently I just got this statement:</p>
  
  <pre><code>SELECT * FROM fruits WHERE delicious &lt;&gt; 0
  </code></pre>
  
  <p>but this would also return apple and banana.</p>
  
  <p>I'm a bit clueless how I could archive that and looking forward to some hints.</p>
  
  <p><strong>EDIT: Thank you very much for your replys. Unfortunately the flag "delicious" is a char and not an integer</strong></p>