select * from (select * from emp order by sal desc)where rownum<=3这样也是可以的
2018-08-22
拿走,不谢,已测试通过
select t3.ci_id as CI_ID,
wm_concat(t3.stu_name) as STU_NAME
from
(
select t1.ci_id,t2.stu_name
from pm_ci t1 cross join pm_stu t2
where instr(t1.stu_ids,t2.stu_id)>0
) t3
group by t3.ci_id;
select t3.ci_id as CI_ID,
wm_concat(t3.stu_name) as STU_NAME
from
(
select t1.ci_id,t2.stu_name
from pm_ci t1 cross join pm_stu t2
where instr(t1.stu_ids,t2.stu_id)>0
) t3
group by t3.ci_id;
最新回答 / 慕斯卡6169147
主要是因为实际应用中会有很多的表。如事实表,维度表。分析数据是会涉及到从众多表中取值,因此会出现很复杂的SQL。小点的需求几百行起步,大点的需求上万行都是正常的。
2018-07-07
已采纳回答 / 闭眼呼吸丶阳光
第一行不要出现空行title col 15 ‘我的报表’ col 35 sql.pnocol deptno heading 部门号col sum(sal) heading 工资总额break on depton skip 1
2018-07-01