SELECT *
FROM (SELECT *
FROM tbl1
WHERE seq = '12345'
ORDER BY score DESC
)
WHERE ROWNUM <= 10
;
UPDATE tbl1
SET yn = 'Y'
WHERE ROWID IN (SELECT rid
FROM (SELECT ROWID rid
FROM tbl1
WHERE seq = '12345'
ORDER BY score DESC
)
WHERE ROWNUM <= 10
)
;
댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.