SQL语句,desc top100条数据出来再asc排序,如何来做? SQL语句,desc top100条数据出来再asc排序,如何来做? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from (select top 100 * from tb order by aa desc)T order by aa asc select * from (select top 100 * from tb order by col desc) t order by col select *from(select top 100 * from tb order by col desc) torder by col asc select * from (select top100 * from tb order by colname desc) a order by colname select * from (select top 10 * from bigdataorder by id) as aorder by id desc 截取部分出 求一条SQL语句 这个递归视图 怎么改成 T-SQl 的?? (难+)一个大数据量的查询问题!(在线等待) 存储过程中,循环语句如何写? 求一个求和的sql语句 附加数据库时出错,帮我看看,我从来没见过的错误! 怎样简单的为某一字段加上随机值 用sql语句批量在表里添加数据?解决就给分、 请教函数的问题 求sql 关于 公用表达式调用
from(select top 100 * from tb order by col desc) t
order by col asc
select * from (
select top 10 * from bigdata
order by id) as a
order by id desc