Question

select top 10 * from property_sell ordey by PropertyID desc; 这条SQL语句报这个错

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '10 * from property_sell ordey by PropertyID' at line 1 请大侠们帮忙看下，我要查询最新的十字记录，但是出错了咯
select top (10) * from property_sell order by PropertyID desc; 是ORDER不是ordey,报错还是一样的

Answer 1

MYSQL的前N行选择是不能使用TOP N这样的形式的。
select top (10) * from property_sell order by PropertyID desc
另外，即使是SQLSERVER数据库，您这个语法也有错误
10是不能加引号的select top 10 * from property_sell order by PropertyID desc
以上才是正确的SQLSERVER语法。
MYSQL语法：select * from property_sell order by propertyid desc limit 0, 10这样的形式
还有ORACLE的语法：SELECT * FROM TABLE WHERE ROWNUM <= 10

Answer 2

select top (10) t.* from property_sell t order by PropertyID desc;
这样就OK了

追问

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.* from property_sell t order by PropertyID desc' at line 1
用你的语句报这个错哦

追答

select top (10), t.* from property_sell t order by PropertyID desc;
这样好了，少了个","号

Answer 3

select top (10) * from property_sell order by PropertyID desc; 这个是ACCESS,MS SQL SERVER里面使用的SQL语句语法
在MYSQL中，使用：
select * from property_sell order by PropertyID desc LIMIT 10;
就能实现相同的效果。