title: How to pick Duplicate Records from SQL Table?
body: <p>SQL Table</p>
  
  <p>How to  pick duplicate records, do i need to use cursor ???</p>
  
  <p>Following is my Query..</p>
  
  <pre><code>select RxNbr,[Fill Date],NDC,GenericCode 
      from vw_TempTransaction 
      order by GenericCode Asc
  </code></pre>
  
  <p>If the Column : RxNbr and Column : [Fill Date] has the same value and repeated more than once, i need to pick those rxnbr / [fill date] records.</p>