由于SQL很简单, 开门见山,直接上SQL。
drop table t1;
CREATE TABLE `t1` (
`id` int(10) NOT NULL AUTO_INCREMENT ,
`name` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`score` int(10) NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
);
INSERT INTO t1(`id`, `name`, `score`) VALUES
(1, 'a', 10),
(2, 'b', 20),
(3, 'c', 30),
(4, 'd', 40),
(5, 'e', 50);
SELECT * from t1;
-- 按score排序,取第一名:
select * from t1 ORDER BY score desc LIMIT 1 ;
-- 按score排序,取第二名:
select * from t1 ORDER BY score desc LIMIT 1,1 ;
-- 按score排序,取前两名:
select * from t1 ORDER BY score desc LIMIT 0,2 ;
-- 按score排序,取score最低的,最后一名:
select * from t1 ORDER BY score asc LIMIT 1 ;
-- 按score排序,取倒数第二名:
select * from t1 ORDER BY score asc LIMIT 1,1 ;
-- 按score排序,取倒数两名:
select * from t1 ORDER BY score asc LIMIT 0,2 ;