[求助]子查询的写法
mzcih 2005-10-21 10:38:00 二级子查询
Select Top 10 * From Pait
Where M_Key <(Select Max(M_Key) From Pait) And Pno Like '%00-13%' Order By M_KEY DESC
得出的结果集是:
M_KEY
20
19
...
10
(数据表共20条符合的记录,分别是1 TO 20,但我只取最大10条,就是11 TO 20条记录)
现在是倒序排列,我想将其重排为升序
我用以下语句但出错:
Select Top 10 * From Pait Where M_Key In
(Select Top 10 * From Pait
Where M_Key <(Select Max(M_Key) From Pait) And Pno Like '%00-13%' Order By M_KEY DESC)
Order By M_Key ASC
最终结果是:
10
11
12
...
20
请问该如何写这句SQL呢?