(1)in()在某个范围(集合)之间
//获得 商品id 为 3, 5, 7 ,8 这几个商品的信息
select goods_name from ecs_goods where goods_id in (3,5,7,8);
(2)Between and 在两个值之间的数据
//查询价格在1000-1500之间的商品信息
select goods_name from ecs_goods where shop_price between 1000 and 1500;
(3)Order by排序 排序方法(升序ASC,降序DESC)
//将获得的商品按照 价格 由高到低 排序
select goods_name,shop_price from ecs_goods order by shop_price desc;
(4)limit限定获得数据的数量
//获得价格最高的前十个商品
select goods_name,shop_price from ecs_goods order by shop_price desc limit 10;
limit 偏移量,想要获得的记录数量
//获得价格最高的 十个商品 除掉最高的前十个
select goods_name,shop_price from ecs_goods order by shop_price desc limit 10,10;