88DAY / MySQL 랭크함수

    SELECT 
        sns_board_no, 
        CASE
        WHEN @prev = liker then @Rank 
        WHEN @prev := liker then @Rank := @Rank +1 
        END AS rank, 
        liker
    FROM 
        (
        SELECT sns_board_no ,count(sns_like_no) as liker
        FROM sns_like
        WHERE MONTH(sns_like_date) = (MONTH(NOW())-1)
        GROUP BY sns_board_no 
        ORDER BY count(sns_like_no) DESC
        )sub1
    CROSS JOIN (select @Rank := 0 ,@prev :=  NULL) sub2
    ;

MySQL 사용자 변수 사용

1)SET을 사용하여 변수설정

SET @exam = 1;

2)@var := expr

SELECT @exam := 1;