Home Forums SQL Server 2008 T-SQL (SS2K8) Filter out records from table RE: Filter out records from table
HanShi
SSC-Dedicated
Points: 33506
More actions
February 7, 2014 at 6:06 am
#1686996
select HName, USERname, max(EndDate) as max_enddate
from #Info
where Description = 'Client'
group by HName, USERname