sql - Show only output from recent date using SSMS -


i trying create query display keys current date.

this table

 vkey         date v-12345     1966-06-14 555658      1986-03-31 v-5666      2011-11-11 v-8533      2011-11-11  v-1111111   2012-02-02  5555501     2012-09-09  v-8236      2013-06-25 v-8533      2015-05-05 v-122154    2016-07-26 v-8562      2015-09-05 v-8533      2016-07-26 

i should

vkey        date v-8533      2016-07-26 v-122154    2016-07-26 

i have tried

 select vkey, max("date") "date"   [testing].[dbo].[vkeystig_ breakdown]   group "vkey" 

but gives me recent date each key.

the simplest way be

 select top (1) ties vkey,                            [date]  [testing].[dbo].[vkeystig_ breakdown]   order [date] desc 

Comments