mysql如何计数_如何使用MySQL和计数和排名

尝试这样的事情：

SELECT ..., C.TOTAL_CNT, (@r := @r + 1) AS rank FROM CUSTOM_LIST, (SELECT @r := 0) t

...

ORDER BY C.TOTAL_CNT DESC

全查询：

SELECT A.place_idx,A.place_id,B.TODAY_CNT,C.TOTAL_CNT, (@r := @r + 1) AS rank

FROM CUSTOM_LIST AS A, (SELECT @r := 0) t

INNER JOIN

(SELECT place_id,COUNT(place_id) AS TODAY_CNT from COUNT_TABLE where DATE(place_date) = DATE(NOW()) GROUP BY place_id)

AS B ON B.place_id=A.place_id

INNER JOIN

(SELECT place_id,COUNT(place_id) AS TOTAL_CNT from COUNT_TABLE GROUP BY place_id)

AS C ON C.place_id=A.place_id

ORDER BY C.TOTAL_CNT DESC

如果我们在Total_CNT中有两个相同的值呢？

也许这样的事情：

SELECT ..., (@last := C.TOTAL_CNT) AS TOTAL_CNT,

IF(@last = C.TOTAL_CNT, @r, @r := @r + 1) AS rank

FROM CUSTOM_LIST, (SELECT @r := 0, @last := -1) t

...