- 출처 : 네이버 지식인 -
SELECT *
FROM(
SELECT a.name
, ROW_NUMBER() OVER(ORDER BY DBMS_RANDOM.RANDOM) AS rn
FROM table1 a
WHERE a.id = 'bruce'
)
WHERE rn = 1
Subscribe
Login
0 Comments