Mysql数据库单表查询2

SELECT * FROM orderitems;
SELECT * FROM fruits;
#先执行from,再执行where,然后执行select
SELECT f_price FROM fruits WHERE f_name='apple';

#查询订单编号,订单中的第几样水果,水果名称
SELECT o_num,o_item,f_name,quantity,item_price FROM fruits,orderitems 
  where fruits.f_id=orderitems.f_id;
 
#查询订单总价大于100的定义编号和总价.注意通过分组再筛选数据不能使用where应该使用having
#SELECT o_num,SUM(quantity*item_price) as 总价 FROM orderitems 
#   WHERE SUM(quantity*item_price)>100 GROUP BY o_num;
SELECT o_num,SUM(quantity*item_price) as 总价 FROM orderitems 
    GROUP BY o_num HAVING SUM(quantity*item_price)>100;
        
#查询水果表前4条记录
SELECT * FROM fruits LIMIT 4;

#查询价格最便宜的4种水果
SELECT * FROM fruits ORDER BY f_price LIMIT 4;

#查询价格排在第3和第4的水果
SELECT * FROM fruits ORDER BY f_price LIMIT 2,2;

SELECT COUNT(f_price) FROM fruits;
SELECT * FROM fruits;
SELECT SUM(f_price) FROM fruits;