# 查询排行
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;
分类: 未分类运维

0 条评论

发表评论

电子邮件地址不会被公开。 必填项已用*标注