title: The Subquery which returns multiple rows in Oracle SQL
body: <p>I have a complex SQL query with multiple sub queries. The Query returns a very big data. The tables are dynamic and they get updated every day. Yesterday, the query didn't execute, because one of the subqueries returned multiple rows. </p>
  
  <p>The subquery would be something like this. </p>
  
  <pre><code>Select Value1 from Table1 where Table1.ColumnName = 123456
  </code></pre>
  
  <p>Table1.ColumnName will be fetched dynamically, nothing will be hardcoded. Table1.ColumnName will be fetched from another subquery which runs perfectly. </p>
  
  <p>My Question would be,</p>
  
  <ol>
  <li>How to find which value in the particular subquery returned two rows. </li>
  </ol>