是这样的,我的条件查询 where TYPE == 2 || TYPE == 3
"select * from UDS_MESSAGE where TOUSERNAME like @user order by TIME DESC";
怎么把上面的条件写到这个语句里面?
"select * from UDS_MESSAGE where TOUSERNAME like @user order by TIME DESC";
怎么把上面的条件写到这个语句里面?
select * from UDS_MESSAGE where TYPE in (2,3) and TOUSERNAME like @user order by TIME DESC
groupby后用这个吧,没有分组用where吧
select * from UDS_MESSAGE where (TYPE == 2 or TYPE == 3) and TOUSERNAME like @user order by TIME DESC