mysql 랭킹 구하기, 석차 구하기, 순위 구하기

mysql 랭킹 구하기

테이블 : ranking

SELECT num, name, score, (

    SELECT COUNT( * ) +1

    FROM ranking

    WHERE score > t.score

) AS rank

FROM ranking AS t

ORDER BY rank ASC 

홍길동 석차 순위

SELECT COUNT(*) +1 FROM ranking WHERE score > ( SELECT score FROM ranking WHERE name =  '홍길동' );