title: Select one row from multi duplicate rows in SQL Server
body: <p>how to select the first of the highlighted rows, but not the second". So, if the order_num and rest_type is the same only return the first one</p>
  
  <p>I need to select rows without duplicate</p>
  
  <p>note : column headerid it created automatic by DB and very important in select </p>
  
  <ul>
  <li><p>the screenshot shows my problem</p>
  
  <p>SELECT 
      [HeaderId],
      [fkPosCloseId],
      [TransNo],
      [fkRestTransType],
      [Total],
      [TransTypeID],
      [TransDate],
      [InsClosed]<br>
  FROM<br>
      DailyTransHeader<br>
  WHERE
      fkPosCloseId = 230642</p></li>
  </ul>
  
  <p>Screenshot illustrating my problem:</p>
  
  <p><img src="https://i.stack.imgur.com/qUgvY.png" alt="My Problem "></p>