![](https://img-blog.csdnimg.cn/20201014180756754.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
钱无极
nothing is impossible!
展开
-
《俗人笔记》之《mysql精华语句总结上》
– 查询英语分数不等于70分的所有同学 select * from exam where english != 70; select * from exam where english <> 70; – 注意 select * from exam where not english = 70; – between:查询英语分数在 80-90之间的同学(包含80和90)。 select ...原创 2019-03-21 19:41:14 · 111 阅读 · 0 评论 -
《俗人笔记》之《mysql精华语句总结下》
– 查询商品的单价大于10的商品,其总价大于30,并降序显示总价 select product as 商品,sum(price) as 总价 from orders where price > 10 group by 商品 having sum(price) > 30 order by 总价 desc; – 笛卡尔积 select * from a,b; – 内连接 select * ...原创 2019-03-21 19:50:05 · 157 阅读 · 0 评论