?怎么用MYSQL写个只选取前两条记录的语句

求助?如何用MYSQL写个只选取前两条记录的语句?

用MSSQL 是这么写的,

例如:select top 2 ID,GoodsName,price,nowprice,picture from tb_goods where sale=1 order by INTime desc

但是用MYSQL怎么写呢?还有个问题MYSQL里有没有类似MSSQL里的money类型?

谢谢大侠们!!!

select top 2 ID,GoodsName,price,nowprice,picture from tb_goods where sale=1 order by INTime desc 

==〉

SQL code


select ID,GoodsName,price,nowprice,picture   from   tb_goods   where   sale=1   order   by   INTime   desc limit 2;

MONEY类型在MYSQL中可以用两步:
1、用DECIMAL类型,
2、用FORMAT函数显示。

比如
select format(2000000.5222,3);


支持ls:
----------
select ID,GoodsName,price,nowprice,picture from tb_goods where sale=1 order by INTime desc limit 2;
?怎么用MYSQL写个只选取前两条记录的语句

相关文章:

你感兴趣的文章:

标签云: