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