MYSQL 그룹별 랭킹 정하기 #MYSQL #RANK
MYSQL 그룹별 랭킹 정하기
SELECT * FROM (
SELECT A.*,
(CASE @VJOB WHEN A.PRODUCT_ID THEN @ROWNUM:=@ROWNUM+1 ELSE @ROWNUM:=1 END) RNUM,
(@VJOB:=A.PRODUCT_ID) VJOB
FROM TB_POST A, (SELECT @VJOB:='', @ROWNUM:=0 FROM DUAL) B
ORDER BY PRODUCT_ID, POST_NM DESC
) AA
#RANK $ROW_NUMBER
