常用sql记录

# 查询排行
SELECT b.* FROM
(
SELECT t.*, @rownum := @rownum + 1 AS rownum
FROM (SELECT @rownum := 0) r,
(SELECT * FROM chenghao ORDER BY score DESC) AS t
) AS b WHERE b.ques_no = '{$quesNo}';

# 查询重复数据
select order_no,count(*) as count from redpack group by order_no having count>1;