Top 1 vs limit 1

MYSQL 支持 LIMIT

SQLSERVER 支持 TOP

SQL Server:
SELECT TOP 10 product, descr, email 
FROM products

ORACLE:
SELECT product, descr, email
FROM products 
WHERE ROWNUM <= 10

MySQL:
SELECT product, descr, email
FROM products
LIMIT 10