升序 Select Id From SMS Where ClassId in (93,94) Order By Id降序 Select Id From SMS Where ClassId in (93,94) Order By Id desc
原来的这个语句是这样的,上面的那个是因为要交流方便都简化的. Select Id,UserName,FromName,Subject,AddTime From SMS Where ClassId=93 and InStr(UserName,'|zitiger|0|')<>0 Order By Id DESC Union Select Id,UserName,FromName,Subject,AddTime From SMS Where ClassId=93 and InStr(UserName,'|zitiger|1|')<>0 Order By Id DESC
降续: Select Id From SMS Where ClassId = 93 Or ClassId=94 Order By Id DESC升续: Select Id From SMS Where ClassId = 93 Or ClassId=94 Order By Id
select * from (Select top 100000 Id,UserName,FromName,Subject,AddTime From SMS Where ClassId=93 and InStr(UserName,'|zitiger|0|')<>0 Order By Id DESC ) tem Union allselect * from ( Select top 100000 Id,UserName,FromName,Subject,AddTime From SMS Where ClassId=93 and InStr(UserName,'|zitiger|1|')<>0 Order By Id DESC ) tem2
Select Id From SMS Where ClassId in (93,94) Order By Id降序
Select Id From SMS Where ClassId in (93,94) Order By Id desc
Select Id,UserName,FromName,Subject,AddTime From SMS Where ClassId=93 and InStr(UserName,'|zitiger|0|')<>0 Order By Id DESC Union Select Id,UserName,FromName,Subject,AddTime From SMS Where ClassId=93 and InStr(UserName,'|zitiger|1|')<>0 Order By Id DESC
Select Id From SMS Where ClassId = 93 Or ClassId=94 Order By Id DESC升续:
Select Id From SMS Where ClassId = 93 Or ClassId=94 Order By Id
Order By Id DESC ) tem Union allselect * from (
Select top 100000 Id,UserName,FromName,Subject,AddTime From SMS Where ClassId=93 and InStr(UserName,'|zitiger|1|')<>0 Order By Id DESC
) tem2