mysql 练习题

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了mysql 练习题，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含1522字，纯文字阅读大概需要3分钟。

内容图文

with temp1 as ( 2 select 1 as id ,111 as barCode,‘A1‘ name union 3 select 2 as id ,112 as barCode,‘A2‘ name union 4 select 3 as id ,200 as barCode,‘B1‘ name union 5 select 4 as id ,230 as barCode,‘B2‘ name union 6 select 5 as id ,140 as barCode,‘B3‘ name 7 ), temp2 as ( 8 select 1 as id ,112 as barCode,10 as Amount,‘2013-10-20‘ Dates union 9 select 2 as id ,112 as barCode,20 as Amount,‘2013-12-20‘ Dates union 10 select 3 as id ,200 as barCode,25 as Amount,‘2014-01-08‘ Dates union 11 select 4 as id ,230 as barCode,30 as Amount,‘2014-03-15‘ Dates union 12 select 5 as id ,112 as barCode,40 as Amount,‘2014-08-7‘ Dates union 13 select 5 as id ,230 as barCode,70 as Amount,‘2014-09-01‘ Dates 14 15 ) 16 17 18 19 20 /* 21 select t2.barCode,t1.name,t2.Amount,t2.dates 22 from temp2 t2 inner join temp1 t1 on t2.barCode=t1.barCode 23 where t1.name like ‘B%‘ and DATES >‘2014-01-01‘ ; 24 */ 25 26 /* 27 select t2.barCode,t1.name,sum(t2.amount) cnt 28 from temp2 t2 left join temp1 t1 on t2.barCode=t1.barCode 29 group by t2.barcode 30 */ 31 32 /* 33 select t2.barCode,t1.name,count(1) cnt 34 from temp2 t2 left join temp1 t1 on t2.barCode=t1.barCode 35 group by t2.barcode 36 having count(t2.barCode)>1 37 */ View Code

 

 

 

 

 

 

mysql 练习题

标签：spl   show   sele   习题   onclick   play   lap   mamicode   sel   

本文系统来源：https://www.cnblogs.com/linbo3168/p/13362593.html

内容总结

以上是互联网集市为您收集整理的mysql 练习题全部内容，希望文章能够帮你解决mysql 练习题所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---