最新回答 / qq_慕神1420022
你的代码在我的浏览器显示不对,真是。。https://www.61bcx.com/scratch3/work/793594https://www.61bcx.com/scratch3/work/764608https://www.61bcx.com/scratch3/work/770067https://www.61bcx.com/scratch3/work/771638https://www.61bcx.com/scratch3/work/767896https://www.61bcx.com/scra...
2018-06-07
最赞回答 / 慕的地2439609
把STU_NAMES用to_char转一下,to_char(WM_CONCAT(STU_NAME) )。应该是oracle高版本得到的WM_CONCAT结果默认是CLOB类型,用to_char转一下就能看到值了
2018-06-01
最赞回答 / qq_星逝风起_0
select ci_id,wm_concat(stu_name) stu_name from pn_ci a,pm_stu bwhere instr(stu_ids,stu_id)>0 group by ci_id;
2018-05-31
最新回答 / 寒山问道
select sum(sal) from emp where deptno=10;select avg(sal) from emp where deptno = 10;试一试估计你Sql写错了吧
2018-04-17
最新回答 / 180416
select d.deptno,d.dname,count(e.empno) from emp e right join dept d on e.deptno=d.deptno group by d.deptno,d.dname;等同于右外连接;两种语句区别也不大,但是外连接的符号位置不常用估计会记错。
2018-02-17