请问这样的SQL怎么写.......

[Air_Mu]

在按‘id’字段排序的20行中，取出按'weight'字段排序的五行。

[chairo]

MSSQL版本：SELECT TOP 5 * FROM table ORDER BY id, weight
MySQL版本：SELECT * FROM table ORDER BY id, weight LIMIT 5

[Air_Mu]

@chairo 我试了下发现不对啊。

[aisk]

select * from xxx where id in (select id from xxx order by id limit 20) order by weight order by weight limit 1 offset 5;

[Air_Mu]

我想了下难道需要先查出行数 x 然后where id>(x-20) order by weight?

[napoleonu]

select * from (select * from tb order by id limit 20) t1 order by weight limit 5;