title: getting same top 1 result in sql server
body: <p>I have this query:</p>
  
  <pre><code>SELECT 
      IT_approvaldate 
  FROM  
      t_item  
  WHERE 
      IT_certID_fk_ind = (SELECT DISTINCT TOP 1 IT_certID_fk_ind 
                          FROM t_item  
                          WHERE IT_rfileID_fk = '4876') 
  ORDER BY 
      IT_typesort
  </code></pre>
  
  <p>Result when running this query:</p>
  
  <p><a href="https://i.stack.imgur.com/wcQJg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wcQJg.png" alt="enter image description here"></a></p>
  
  <p>I need get top 1 result. (2013-04-27 00:00:00) problem is when I select top 1, getting 2nd result.</p>
  
  <p><a href="https://i.stack.imgur.com/7sfzV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7sfzV.png" alt="enter image description here"></a></p>
  
  <p>I believe reason for that order by column value same in those two result.
  please see below,</p>
  
  <p><a href="https://i.stack.imgur.com/3qBAR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3qBAR.png" alt="enter image description here"></a></p>
  
  <p>However I need get only <code>IT_approvaldate</code> column top 1 as result of my query. </p>
  
  <p>How can I do this? Can anyone help me to solve this?</p>
  
  <p><a href="https://i.stack.imgur.com/kaAtK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kaAtK.png" alt="enter image description here"></a></p>