php - 从sql中选择前50条记录

Question

我有以下数据库表名 tbl_rec

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

我在这个表中有大约 5000 条记录。

我想选择前 50 个高分记录。

我不能使用 limit 语句，因为我已经在使用 limit 进行分页。

谢谢

Answer 1

i want to select first 50 higher points records.

然后:

  SELECT tr.*
    FROM TBL_REC tr
ORDER BY tr.points DESC
   LIMIT 50

i can't use limit statement as i am already using limit for paging.

然后使用子查询:

SELECT x.*
  FROM (SELECT tr.*
          FROM TBL_REC tr
      ORDER BY tr.points DESC
         LIMIT 50) x
 LIMIT a, b --for your pagation