根据ms-access视图:
SELECT TOP(5) * FROM customers ORDER BY customerName;
正确的语法是:
SELECT TOP 5 * FROM customers ORDER BY customerName;
(请注意括号)。
Access数据库LIMIT关键字
根据ms-access视图:
SELECT TOP(5) * FROM customers ORDER BY customerName;
正确的语法是:
SELECT TOP 5 * FROM customers ORDER BY customerName;
(请注意括号)。