select point from table order by point DESC LIMIT 0,5; or select point from table order by point DESC LIMIT 5;
如果是mysql就使用 2楼的方法。如果是 sql server数据库就是:select top 5 * from tableName where .... order by ... oracle:select X,X from (select X,X,rownum r from tableName where ... order by ..) where r<6
or
select point from table order by point DESC LIMIT 5;
sql server数据库就是:select top 5 * from tableName where .... order by ...
oracle:select X,X from (select X,X,rownum r from tableName where ... order by ..) where r<6