select Category from(select distinct Category from T_Detail where CREATED_BY= @CREATED_BY AND RecordDate>=@RecordDate1 AND RecordDate<@RecordDate2)t group by Category
说明： CREATED_BY 为创建人ID
RecordDate为创建日期
SQL Server select 将类型相同的行合并,布布扣,bubuko.com
原文：http://www.cnblogs.com/kangjing/p/3718626.html