SQL面试题
ssssaaaawe
这个作者很懒,什么都没留下…
展开
-
SQL面试题
#求每篇文章(标题)最后更新的版本号和修订日期 SELECT title,MAX(version),MAX(amenddate) from version v,article a where v.articleid = a.articleid GROUP BY title原创 2019-10-28 13:54:32 · 198 阅读 · 0 评论 -
SQL面试题
#求销售额最少的前三种商品名称及成交总金额 SELECT p.name,IF(SUM(priceAMOUNT) is NULL,0,SUM(priceAMOUNT)) ‘总价’ FROM goods g RIGHT JOIN product p ON g.ID = p.id GROUP BY name ORDER BY SUM(price*AMOUNT) ASC LIMIT 3 IF(SUM...原创 2019-10-28 13:31:23 · 232 阅读 · 0 评论