title: How to get rows from a SQL table just ignoring the rows which have duplicate values in one particular column
body: <p>I know that if I want to have distict values in case of duplicates, I can use DISTINCT. But what I want is that if there is a duplicate value in one of the columns, I don't need any row from that .</p>
  <p>eg.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>ORDER_ID</th>
  <th>NAME</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>ORD1</td>
  <td>Aaron</td>
  </tr>
  <tr>
  <td>ORD2</td>
  <td>BOB</td>
  </tr>
  <tr>
  <td>ORD3</td>
  <td>Carry</td>
  </tr>
  <tr>
  <td>ORD1</td>
  <td>Danny</td>
  </tr>
  <tr>
  <td>ORD2</td>
  <td>Emily</td>
  </tr>
  <tr>
  <td>ORD2</td>
  <td>Frank</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>In this case, I just want the result as:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>ORDER_ID</th>
  <th>NAME</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>ORD3</td>
  <td>Carry</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Since ORD1 and ORD3 are repeated.</p>