Air_Mu
V2EX  ›  问与答

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

  •  
  •   Air_Mu · Jan 15, 2013 · 3380 views
    This topic created in 5056 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
    chairo
    Jan 15, 2013❤️2
    1
    MSSQL版本:SELECT TOP 5 * FROM table ORDER BY id, weight
    MySQL版本:SELECT * FROM table ORDER BY id, weight LIMIT 5
    Air_Mu
    Air_Mu
    OP
    Jan 15, 2013
    2
    @chairo 我试了下发现不对啊。
    aisk
    aisk
    Jan 15, 2013
    3
    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
    Air_Mu
    OP
    Jan 15, 2013
    4
    我想了下难道需要先查出行数 x 然后where id>(x-20) order by weight?
    napoleonu
    napoleonu
    Feb 8, 2013
    5
    select * from (select * from tb order by id limit 20) t1 order by weight limit 5;
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   2523 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 27ms · UTC 11:06 · PVG 19:06 · LAX 03:06 · JFK 06:06
    ♥ Do have faith in what you're doing.