示例数据:
emp表
---------------------------------------------------------------------------------------------------------------------------------
SQL server:
SELECT DISTINCT TOP 10 DEPTNO FROM EMP;
MySQL:
SELECT DISTINCT DEPTNO FROM EMP LIMIT 10;
Oracle:
SELECT DISTINCT DEPTNO FROM EMP WHERE ROWNUM <= 11;