title: Delete only one row from a table where the duplicate (value, maybe date even) is not in all columns
body: <p>I have a table lets say Tab1</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">id</th>
  <th style="text-align: center;">dt</th>
  <th style="text-align: center;">price</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">01/01/2021</td>
  <td style="text-align: center;">50</td>
  </tr>
  <tr>
  <td style="text-align: center;">2</td>
  <td style="text-align: center;">01/22/2021</td>
  <td style="text-align: center;">70.8</td>
  </tr>
  <tr>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">01/01/2021</td>
  <td style="text-align: center;">49.99</td>
  </tr>
  <tr>
  <td style="text-align: center;">2</td>
  <td style="text-align: center;">01/21/2021</td>
  <td style="text-align: center;">69</td>
  </tr>
  <tr>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">01/14/2021</td>
  <td style="text-align: center;">54</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Now, I must delete all the rows that have duplicate date and id column, irrespective of the value column (any one can stay, because values will be very near)
  So, the final table after the operation would be</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">id</th>
  <th style="text-align: center;">dt</th>
  <th style="text-align: center;">price</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">01/01/2021</td>
  <td style="text-align: center;">50</td>
  </tr>
  <tr>
  <td style="text-align: center;">2</td>
  <td style="text-align: center;">01/22/2021</td>
  <td style="text-align: center;">70.8</td>
  </tr>
  <tr>
  <td style="text-align: center;">2</td>
  <td style="text-align: center;">01/21/2021</td>
  <td style="text-align: center;">69</td>
  </tr>
  <tr>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">01/14/2021</td>
  <td style="text-align: center;">54</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>(No order necessary)</p>
  <p>What is the fastest way in terms of time taken to run the query, to solve this?</p>
  <p>My Question and this question is different as not all the columns of the duplicate rows of mine are same
  <a href="https://stackoverflow.com/questions/18390574/how-to-delete-duplicate-rows-in-sql-server">How to delete duplicate rows in SQL Server?</a></p>