title: How to get latest record date from column
body: <p>I want to return the date and ID for the latest added record in on of our tables.
  can anyone suggest right query for that plz. We are using sqlServer</p>
  
  <pre><code>SELECT [BGArx_ID], [BGArx_PUBLISHED_DATE]      
  FROM TECH_ARTICLES   
  WHERE [BGArx_PUBLISHED_DATE] = ???
  </code></pre>