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
Post a Comment