mysql order by

select goods_name,cat_id,shop_price from goods where cat_id=4 order by shop_price desc;

select cat_id,shop_price,goods_name from goods order by cat_id ,shop_price;

select goods_id,goods_name from goods where cat_id=3 order by shop_price asc limit 10;

mysql> select goods_name ,shop_price from goods order by shop_price desc limit 0,5;

mysql> select goods_name ,shop_price from goods order by shop_price desc limit 5; +----------------+------------+ | goods_name | shop_price | +----------------+------------+ | 多普达Touch HD | 5999.00 | | 诺基亚N96 | 3700.00 | | 诺基亚N85 | 3010.00 | | testPhone | 3000.00 | | 夏新T5 | 2878.00 | +----------------+------------+

mysql> select goods_name ,shop_price from goods order by shop_price desc limit 2,3; +------------+------------+ | goods_name | shop_price | +------------+------------+ | 诺基亚N85 | 3010.00 | | testPhone | 3000.00 | | 夏新T5 | 2878.00 | +------------+------------+

mysql> select goods_name ,shop_price from goods order by shop_price desc limit 1; +----------------+------------+ | goods_name | shop_price | +----------------+------------+ | 多普达Touch HD | 5999.00 | +----------------+------------+

select cat_id, goods_id ,goods_name from( (select cat_id,goods_id ,goods_name from goods order by cat_id desc,goods_id desc ) as tmp )group by cat_id order by cat_id desc;

select cat_id,goods_id ,goods_name from goods where goods_id in ( select max(goods_id) from goods group by cat_id ) order by cat_id desc;