mysql - sql选择前10条记录

Question

我有下表(点):

    recno   uid   uname   points
    ============================
    1       a     abc      10
    2       b     bac      8
    3       c     cvb      12
    4       d     aty      13
    5       f     cyu      9
    -------------------------
    --------------------------

我需要的是只显示前十条记录，每页显示5条记录。我有以下 SQL 语句:

    select * from points where uid in(a,c) order by uid LIMIT 1, 5

谢谢

Answer 1

对于第一页:

SELECT * FROM points p ORDER BY points DESC LIMIT 0, 5

对于第二页:

SELECT * FROM points p ORDER BY points DESC LIMIT 5, 5