MYSQL 排位计算

SELECT * FROM (
SELECT (
SELECT COUNT(zkzh)+1 FROM tcj WHERE cj>a.cj) AS rank,
a.zkzh, a.cj FROM tcj AS a) AS b
WHERE b.rank<=35 ORDER BY b.rank;

DELIMITER $$
CREATE FUNCTION rank(str_zkzh VARCHAR(10))
RETURNS INT
BEGIN
DECLARE rank INT;
DECLARE score INT;
SELECT cj FROM wcj WHERE zkzh=str_zkzh ORDER BY cj DESC LIMIT 1 INTO score;
SELECT COUNT(zkzh)+1 FROM wcj WHERE cj>score INTO rank;
RETURN(rank);
END $$
DELIMITER ;

SELECT a1.Name, a1.Sales, COUNT(a2.sales) Sales_Rank
FROM Total_Sales a1, Total_Sales a2
WHERE a1.Sales < a2.Sales or (a1.Sales=a2.Sales and a1.Name = a2.Name)
GROUP BY a1.Name, a1.Sales
ORDER BY a1.Sales DESC, a1.Name DESC;
结果： www.2cto.com