Something I needed today... I wish this was standarized, but it is not, so here are some examples:
SQL Server:
SELECT TOP 10 product, descr, email
FROM products
FROM products
ORACLE:
SELECT product, descr, email
FROM products
WHERE ROWNUM <= 10
FROM products
WHERE ROWNUM <= 10
MySQL:
SELECT product, descr, email
FROM products
LIMIT 10
FROM products
LIMIT 10
151

被折叠的 条评论
为什么被折叠?



