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

V2EX = way to explore

V2EX 是一个关于分享和探索的地方

For Existing Member Sign In

This topic created in 4858 days ago, the information mentioned may be changed or developed.

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

Supplement 1 · Jan 15, 2013

1楼的好像不行
似乎只有第一个字段相同的时候才按第二个字段排序。
并且也没有在按ID排序的20行里筛选？

Supplement 2 · Feb 7, 2013

继续问一下。

5 replies • 1970-01-01 08:00:00 +08:00

chairo

Jan 15, 2013

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

Air_Mu

Jan 15, 2013

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

aisk

Jan 15, 2013

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

Jan 15, 2013

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

napoleonu

Feb 8, 2013

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