title: Compare multiple values in a single column oracle
body: <p>I want to compare multiple values of a column with a single value of another column.I had tried a lot but it gives me "No row selected" 
  here's my scenario...</p>
  
  <p>I have a table <strong>Bus_stop_table</strong>: </p>
  
  <p>Bus_ID(FK) ------STOP_ID</p>
  
  <p>201 -------------------401</p>
  
  <p>201 -------------------402</p>
  
  <p>201--------------------403</p>
  
  <p>202 -------------------401</p>
  
  <p>202 -------------------405</p>
  
  <p>203 -------------------403</p>
  
  <p>203 -------------------406</p>
  
  <p>I have to choose a bus_id who has both stop_id 401 and 403. which is 201
  but when i try to find this I didn't get the desired result..
  here's my queries</p>
  
  <pre><code>SELECT BUS_ID,stop_id FROM BUS_STOP_TABLE WHERE STOP_ID =all(401,405);
  </code></pre>
  
  <p>and</p>
  
  <pre><code>SELECT BUS_ID,stop_id FROM BUS_STOP_TABLE WHERE STOP_ID 401 and STOP_ID = 
  405;
  
  SELECT BUS_ID,stop_id FROM BUS_STOP_TABLE WHERE STOP_ID 401 and STOP_ID = 
  405 group by (bus_id , stop_id);
  </code></pre>
  
  <p>Please anyone can help me.</p>