我有以下表格 (points):
recno uid uname points
============================
1 a abc 10
2 b bac 8
3 c cvb 12
4 d aty 13
5 f cyu 9
-------------------------
--------------------------
我需要展示按照分数(降序)排列的前十条记录,并且每页显示五条记录。以下是SQL语句:
select * from points where uid in(a,c) order by uid LIMIT 1, 5
谢谢