SQL :: 상위 N개 데이터 출력하기 (mssql, oracle, mysql)

 

1. MSSQL

SELECT TOP 100 name, age, dept from [table명];

2. ORACLE

SELECT name, age, dept from [table명] where rownum<=n;

3. MySQL

SELECT name, age, dept from [table명] LIMIT n;