title: Select statement having multiple conditions over multiple columns
body: <p>A part of my table is as follows,</p>
  
  <pre><code>Key|Value
  ---------
   A | V1
   B | V2
   C | V3
  </code></pre>
  
  <p>I know the following query would definitely return no result, but then what is the correct query of achieving a positive result, i.e. '1'.</p>
  
  <p>I mean what query should I apply that checks that A has a value as V1 and B has a value as V2 and then returns me '1'. 
  The new query should fail to return anything if either A or B has different results.</p>
  
  <p>Assume the table as a Map of key/value pairs. Only difference here is it's not a Java map but a table in Oracle Db. So, how to achieve a result that satisfies both the key/value pairs.</p>
  
  <pre><code>select 1 from myTable 
  where (key = 'A' and value = 'V1') 
    AND (key = 'B' and value = 'V2');
  </code></pre>
  
  <p>Let me know if the design of the table itself needs some change.</p>