SQL Server select 将类型相同的行合并

2022-05-24 12:23:04

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