SQL子表排序问题

发布网友发布时间：2023-09-19 12:50

共5个回答

热心网友时间：2023-09-19 15:22

select * from table1
where id = (select min(id) from (select top 3 id from table1 order by id desc ) as tmp)

子表可以排序。

热心网友时间：2023-09-19 15:23

select * from table_name where id in (select min(a.id) from
(select top 3 id from table_name order by id desc) a) b)

热心网友时间：2023-09-19 15:23

select top 1 * from page_infor2 where id=(select top 1 id from
(select top 3 id from page_infor2 order by id desc) a) order by id

热心网友时间：2023-09-19 15:24

select top 1 * from [count] where id in
(select top 3 id from [count] order by id desc) order by id asc

热心网友时间：2023-09-19 15:24

select top 3 id from tablename where id = '97' order by id desc

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com