title: How can I retrieve all data and label the one that are the newest as the new data?
body: <p>I have a table named Standards that includes ID, StandardsFamiliy, Standards,Date and Link.
  I want to show all data, but I want the newest date in same StandardsFamily and Standards labeled as the newest one.
  For example if I have </p>
  
  <pre><code>StandardFamily,  Standards, Date
  A                   a        2018
  A                   a        2017
  B                   b        2016
  C                   c        2010
  C                   c        2011
  C                   c        2011
  C                   c2       2018
  </code></pre>
  
  <p>I want to retrieve this:</p>
  
  <pre><code>StandardFamily,  Standards, Date,  Status
  A                   a        2018   New
  A                   a        2017   Old
  B                   b        2016   New
  C                   c        2010   Old
  C                   c        2011   Old
  C                   c        2012   New
  C                   c2       2018   New
  </code></pre>
  
  <p>I know how to retrieve only the newest one with following query:</p>
  
  <pre><code>select * 
  from Standards
  where (StandardFamily,Standards,Date) 
  IN (select StandardFamily,Standards,Max(Date) from Standards group by StandardFamily,Standards)
  </code></pre>
  
  <p>I think I might to follow something like</p>
  
  <pre><code>select
  case when (...) then "New" else "Old" end
  from Table
  </code></pre>
  
  <p>Any help would be appreciated! :)</p>