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