데이터베이스/MYSQL

ROWNUM

죠부니 2020. 1. 13. 20:50
반응형

SELECT @ROWNUM:=@ROWNUM+1 as rownum, ci.* FROM sample sp,(SELECT @ROWNUM:=0) R

WHERE 1=1ORDER BY rownum DESC,sp.idx DESC LIMIT 0,10

반응형