New: rownum

miawoo (25)in oracle • 7 years ago
oracle rownum
SELECT ROWNUM, E.* FROM EMP E ORDER BY E.SAL DESC; -- CTRL + ENTER : 쿼리실행 SELECT ROWNUM, T.* FROM (SELECT * FROM EMP ORDER BY SAL DESC) T; SELECT * FROM (SELECT ROWNUM AS RNUM, T.* FROM…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.00
3