28,391
社区成员
发帖
与我相关
我的任务
分享
select top 5 c_name,c_stu from class where c_stu>30 and c_type=1
and c_name like '%二班%' order by c_stu asc ,c_type desc
select * from
(select top 5 c_name,c_stu from test
where c_stu>30 and c_type=true and c_name like '%二班%'
order by c_stu asc) th
order by c_type desc