1、Top问题
SQL Server:
SELECT TOP 10 product, descr, email
FROM products order by product
ORACLE:
SELECT product, descr, email
FROM (select * from products order by product)
WHERE ROWNUM <= 10
1、Top问题
SQL Server:
SELECT TOP 10 product, descr, email
FROM products order by product
ORACLE:
SELECT product, descr, email
FROM (select * from products order by product)
WHERE ROWNUM <= 10