tsql - Select values by date -

tsql - Select values by date -

i have same info construction select lastly value of date? , need values each date, marked them. solution feroc's question giving lastly date only.

localname date_time rh bag012 2014-10-09 17:17:58.000 16 <-- bag012 2014-10-09 17:13:28.000 16 bag012 2014-10-09 17:12:23.000 16 bag012 2014-10-09 16:52:54.000 16 bag012 2014-10-08 05:14:56.000 16 <-- bag012 2014-10-08 04:45:31.000 16 bag012 2014-10-08 04:44:08.000 16 sag165 2014-10-28 11:22:14.000 698 <-- sag165 2014-10-28 11:09:14.000 698 sag165 2014-10-28 10:53:18.000 698 sag165 2014-10-27 19:30:14.000 693 <-- sag165 2014-10-27 19:14:51.000 693 sag165 2014-10-27 19:13:56.000 693

here code using:

with cte ( select ltrim(localname) localname, cast(year(date_time) varchar)+'-'+cast(month(date_time) varchar)+'-'+cast(day(date_time) varchar) date_time, rh, tank, mode, rn = row_number() on (partition localname order date_time desc) dbo.smcdata ) select distinct date_time, localname, rh, tank, mode cte rn = 1 order localname asc as datetime includes time also, tried remove time , leave date. tried used distinct date_time

both above cases not making changes in result.

answer: all, next worked me:

with cte ( select localname, date_time, rh, rn = row_number() on (partition localname, cast(date_time date) order date_time desc) dbo.tablename ) select localname, date_time, rh cte rn = 1 order localname, date_time;

with cte ( select localname, date_time, rh, rn = row_number() on (partition localname, cast(date_time date) order date_time desc) dbo.tablename ) select localname, date_time, rh cte rn = 1 order localname, date_time;

tsql sql-server-2012