sql 排序问题

SQL code:

select * into tb from (
select 1 id ,'AS' name
union all
select 11,'AS'
union all
select 2,'AS'
union all
select 333,'AS'
union all
select 4,'AS'
union all
select 5,'AS'
union all
select 6,'AS'
union all
select 66,'AS'
union all
select 77,'AS'
union all
select 88,'AS'
union all
select 99,'AS'
union all
select 1,'AS'
union all
select 111,'AS' )a



先从小到大排离，排序后的前十条数据从大到小排序

---

顶起

---

SQL code:

select * from (
select top 10 * from tb order by id asc ) t order by id desc;

---

--呵呵：20分真容易..............

---

SQL code:
select * into tb from (
select 1 id ,'AS' name
union all
select 11,'AS'
union all
select 2,'AS'
union all
select 333,'AS'
union all
select 4,'AS'
union all
select 5,'AS'
union all
select 6,'AS'
union all
select 66,'AS'
union all
select 77,'AS'
union all
select 88,'AS'
union all
select 99,'AS'
union all
select 1,'AS'
union all
select 111,'AS' )a


SELECT *
from tb AS A
ORDER BY
CASE WHEN ROW_NUMBER() OVER(ORDER BY id) <= 10 THEN 0 ELSE 1 END,
CASE WHEN ROW_NUMBER() OVER(ORDER B