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为创建日期
kangjing 2014-05-09 12:00 原文
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为创建日期