MySQL中是否有任何方法可以获取表的前10行.
i、 例如...
SELECT TOP 10 distinct *
FROM people
WHERE names='SMITH'
ORDER BY names asc
然而,这个方法实际上不起作用,因为它给出了错误:"语法错误.查询表达式中缺少运算符distinct*"
MySQL中是否有任何方法可以获取表的前10行.
i、 例如...
SELECT TOP 10 distinct *
FROM people
WHERE names='SMITH'
ORDER BY names asc
然而,这个方法实际上不起作用,因为它给出了错误:"语法错误.查询表达式中缺少运算符distinct*"
SELECT DISTINCT *
FROM people
WHERE names = 'Smith'
ORDER BY
names
LIMIT 10