为了账号安全，请及时绑定邮箱和手机立即绑定

课程

/数据库

/Oracle

/Oracle高级查询

在PL/SQL客户端，怎么代码实现 break on deptno skip 1

--break on deptno skip 2;

select distinct deptno,job,sum(sal)

from emp

group by rollup(deptno,job);


慕粉1470114675

2018-06-07

源自：Oracle高级查询  2-11

关注问题 我要回答
2281
操作
收起

正在回答

2 回答

qq_慕神1420022
2022-03-30

你的代码在我的浏览器显示不对，真是。。

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/scratch3/work/784351https://www.61bcx.com/scratch3/work/791423https://www.61bcx.com/scratch3/work/767160https://www.61bcx.com/scratch3/work/781193https://www.61bcx.com/scratch3/work/789679https://www.61bcx.com/scratch3/work/788195https://www.61bcx.com/scratch3/work/792180https://www.61bcx.com/scratch3/work/784996https://www.61bcx.com/scratch3/work/771086https://www.61bcx.com/scratch3/work/766793https://www.61bcx.com/scratch3/work/786154https://www.61bcx.com/scratch3/work/773094https://www.61bcx.com/scratch3/work/764261https://www.oschina.net/search?scope=news&q=%E7%BC%85%E7%94%B8%E6%9E%9C%E6%95%A2%E8%85%BE%E9%BE%99%E5%85%AC%E5%8F%B8%E5%AE%98%E7%BD%91%E5%BC%80%E6%88%B7%E5%BE%AE%E4%BF%A1%E5%BC%80%E6%88%B7%E7%94%B5%E8%AF%9D%E7%BD%91%E5%9D%80TL262.%EF%BC%A3%EF%BC%AF%EF%BC%AD%E4%B8%8A%E9%A5%B6%E7%BE%8E%E9%A3%9F&days=0&onlytitle=0&sort_by_time=0https://wap.zol.com.cn/index.php?c=List_List&keyword=%E4%B8%9C%E6%96%B9%E6%98%8E%E7%8F%A0%E6%B3%A8%E5%86%8C%E7%BD%91%E5%9D%80%E5%BE%AE%E4%BF%A1%E5%BC%80%E6%88%B7%E7%94%B5%E8%AF%9D%E5%AE%98%E7%BD%91TL262%C2%B7C%EF%BC%AFM%E5%95%86%E4%B8%98%E6%AF%95%E4%B8%9A%E7%94%9Fhttp://www.vpansou.com/query?wd=%E6%B5%99%E6%B1%9F%E9%BE%99%E6%B3%89%E6%89%8B%E6%9C%BA%E7%BD%91%E6%8A%95%E5%B9%B3%E5%8F%B0%E6%8E%A8%E8%8D%90B2024%C2%B7CN%E8%BE%BD%E6%BA%90%E9%93%81%E9%80%9A%EF%BD%8C%EF%BD%91https://mod.3dmgame.com/mods?mods_title=%E9%BE%99%E8%85%BE%E5%A8%B1%E4%B9%90%E6%89%8B%E6%9C%BA%E7%89%88%E4%B8%8B%E8%BD%BD%E3%80%90TL262%C2%B7%EF%BC%A3%EF%BC%AF%EF%BC%AD%E6%AC%A2%E8%BF%8E%E6%82%A8%E3%80%91%E7%99%BE%E8%89%B2%E5%A4%A7%E5%AD%A6http://iias.tsinghua.edu.cn/search/%E9%BB%91%E9%BE%99%E6%B1%9F%E4%BC%8A%E6%98%A5%E7%9C%9F%E4%BA%BA%E6%96%97%E7%89%9B%E3%80%90%E5%AE%98%E7%BD%91%E2%86%92TL262%C2%B7C%EF%BC%AFM%E3%80%91%E6%B1%89%E4%B8%AD%E9%AB%98%E6%A0%A1http://dblab.xmu.edu.cn/?s=%E6%96%B0%E9%87%91%E5%AE%9D%E5%9C%A8%E7%BA%BF%E5%AE%A2%E6%9C%8D%E7%BD%91%E9%A1%B5%E7%89%88%E5%BE%AE%E4%BF%A1%E5%AE%98%E7%BD%91B2024%C2%B7CN%E9%82%AF%E9%83%B8%E5%8D%AB%E7%94%9F%E5%B1%80https://minecraft.fandom.com/zh/wiki/UserProfile:%E9%91%AB%E4%BD%B0%E5%88%A9%E5%A8%B1%E4%B9%90%E5%A4%9A%E5%B0%91%E5%B9%B4%E4%BA%86%E7%9B%B4%E8%90%A5%E7%BD%91B2024.CN%E5%90%89%E6%9E%97%E8%AE%BF%E8%B0%88?variant=zh-hk&cb=&mobileaction=toggle_view_mobilehttps://db.auto.sina.com.cn/search/?search_txt=%E7%9A%87%E5%AE%B6%E5%9B%BD%E9%99%85%E5%9C%A8%E7%BA%BF%E5%85%AC%E5%8F%B8%E5%B9%B3%E5%8F%B0%E3%80%90B2024%C2%B7CN%E6%AC%A2%E8%BF%8E%E6%82%A8%E3%80%91%E8%AE%B8%E6%98%8C%E7%94%9F%E6%B4%BBhttps://wap.zol.com.cn/index.php?c=List_List&keyword=%E9%91%AB%E8%83%9C%E6%88%90%E5%A8%B1%E4%B9%90%E7%BD%91%E7%AB%99%E3%80%90B2024%C2%B7CN%E6%AC%A2%E8%BF%8E%E6%82%A8%E3%80%91%E8%B5%A4%E5%B3%B0%E6%8B%9B%E8%81%98https://mod.3dmgame.com/mods?mods_title=%E7%BC%85%E7%94%B8%E7%BC%85%E5%8C%97%E5%A8%B1%E4%B9%90%E6%89%8B%E6%9C%BAapp%E5%BE%AE%E4%BF%A1%E5%BC%80%E6%88%B7%E7%94%B5%E8%AF%9D%E5%AE%98%E7%BD%91B2024%C2%B7CN%E9%B9%A4%E5%B2%97%E7%84%A6%E7%82%B9http://dblab.xmu.edu.cn/?s=%E7%BC%85%E7%94%B8%E7%9A%87%E5%AE%B6%E5%9B%BD%E9%99%85%E5%A8%B1%E4%B9%90%E5%BC%80%E6%88%B7%E6%8E%A8%E8%8D%90B2024%C2%B7CN%E6%98%AD%E9%80%9A%E7%BE%8E%E9%A3%9F%EF%BC%8D%EF%BC%98https://iias.tsinghua.edu.cn/search/%E6%96%B0%E7%99%BE%E8%83%9C%E5%A8%B1%E4%B9%90%E6%AC%A2%E8%BF%8E%E6%82%A8%E5%AE%98%E6%96%B9%E7%BD%91%E5%9D%80B2024.CN%E6%97%A5%E7%85%A7%E9%93%81%E9%80%9A/feed/rss2/http://dblab.xmu.edu.cn/?s=%E6%9E%9C%E6%95%A2%E7%9A%87%E5%AE%B6%E5%88%A9%E5%8D%8E%E5%90%B4%E6%96%8C%E3%80%90%E5%AE%98%E7%BD%91%E2%86%92TL262%C2%B7%EF%BC%A3%EF%BC%AF%EF%BC%AD%E3%80%91%E9%81%B5%E4%B9%89%E5%8C%BB%E4%BF%9D%EF%BD%95https://minecraft.fandom.com/zh/wiki/UserProfile:%E6%B5%99%E6%B1%9F%E4%B9%90%E6%B8%85%E7%BD%91%E4%B8%8A%E9%BE%99%E8%99%8E%E6%B8%B8%E6%88%8F%E7%BD%91%E5%9D%80TL262%C2%B7C%EF%BC%AFM%E9%BB%84%E5%86%88%E5%8D%AB%E8%A7%86?variant=zh-hk&cb=&mobileaction=toggle_view_mobilehttps://list.jd.com/search?keyword=%E7%BC%85%E7%94%B8%E4%B8%87%E4%B8%B0%E5%9B%BD%E9%99%85%E8%80%81%E7%99%BE%E8%83%9C%E5%8E%85%E4%BB%A5%E7%BC%85%E7%94%B8%E6%9E%9D%E3%80%90%E5%AE%98%E7%BD%91%E2%86%92B2024%C2%B7CN%E3%80%91%E6%96%B0%E4%B9%A1%E7%BD%91%E7%BA%A2https://www.oschina.net/search?scope=all&q=%E7%BD%91%E4%B8%8A%E7%BD%91%E8%B5%8C%E7%9C%9F%E4%BA%BA%E5%AE%9E%E4%BD%93%E8%80%81%E5%B9%B3%E5%8F%B0%E5%BE%AE%E4%BF%A1%E3%80%90B2024%C2%B7CN%E6%AC%A2%E8%BF%8E%E6%82%A8%E3%80%91%E9%BE%99%E5%B2%A9%E5%88%86%E7%AB%99http://www.vpansou.com/query?wd=%E7%9A%87%E5%AE%B6%E5%9B%BD%E9%99%85%E5%B9%B3%E5%8F%B0%E6%80%BB%E6%B1%87%E7%94%B5%E8%AF%9D%E3%80%90TL262%C2%B7%EF%BC%A3%EF%BC%AF%EF%BC%AD%E6%AC%A2%E8%BF%8E%E6%82%A8%E3%80%91%E6%A6%86%E6%9E%97%E7%94%B5%E5%8F%B0%EF%BD%9Ehttps://www.oschina.net/search?scope=all&q=%E7%9A%87%E5%AE%B6%E5%9B%BD%E9%99%85%E5%A8%B1%E4%B9%90%E7%9B%B4%E8%90%A5%E5%AE%98%E6%96%B9%E7%BD%91%E5%9D%80TL262%C2%B7%EF%BC%A3%EF%BC%AF%EF%BC%AD%E9%98%B3%E6%B3%89%E7%BE%8E%E9%A3%9Fhttps://www.oschina.net/search?scope=news&q=%E6%96%B0%E9%94%A6%E6%B1%9F%E5%85%AC%E5%8F%B8TL262%C2%B7C%EF%BC%AFM%E6%B8%AD%E5%8D%97%E4%BA%BA%E6%89%8D%E7%BD%91%EF%BC%90&days=0&onlytitle=0&sort_by_time=0http://www.minitu.cn/?s=%E7%BC%85%E7%94%B8%E9%BE%99%E6%BA%90%E5%9B%BD%E9%99%85%E9%9B%86%E5%9B%A2%E7%8E%B0%E5%9C%BA%E7%BB%8F%E7%90%86%E7%9B%B4%E8%90%A5%E7%BD%91TL262%C2%B7%EF%BC%A3%EF%BC%AF%EF%BC%AD%E9%BB%84%E7%9F%B3%E4%BC%81%E4%B8%9A%EF%BD%89%EF%BC%94https://www.oschina.net/search?scope=news&q=%E7%A6%8F%E5%BB%BA%E8%8E%86%E7%94%B0%E5%93%AA%E9%87%8C%E8%83%BD%E7%8E%A9%E5%BA%84%E5%92%8C%E9%97%B2%E3%80%90%E5%AE%98%E7%BD%91%E2%86%92B2024%C2%B7CN%E3%80%91%E4%B8%9C%E8%8E%9E%E4%BD%93%E8%82%B2%EF%BD%8E%EF%BC%B3&days=0&onlytitle=0&sort_by_time=0http://gdh.dict.cn/%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E6%89%8B%E6%9C%BA%E7%89%88%E7%BD%91%E7%9B%B4%E8%90%A5%E5%BC%80%E6%88%B7%3ATL262%C2%B7C%EF%BC%AFM%E9%92%A6%E5%B7%9E%E7%BE%8E%E9%A3%9Fhttps://search.bilibili.com/all?keyword=%E9%91%AB%E7%99%BE%E5%88%A9%E5%A8%B1%E4%B9%90%E5%8E%85%E5%AE%98%E7%BD%91B2024%C2%B7CN%E8%A5%84%E6%A8%8A%E6%AF%95%E4%B8%9A%E7%94%9Fhttps://www.oschina.net/search?scope=news&q=%E7%BC%85%E7%94%B8%E7%9A%87%E5%AE%B6%E8%B5%8C%E5%9C%BA%E5%9C%A8%E4%B8%AD%E5%9B%BD%E6%80%8E%E4%B9%88%E7%8E%A9%E5%BC%80%E6%88%B7TL262.c%EF%BC%AF%EF%BC%AD%E9%83%91%E5%B7%9E%E7%83%AD%E9%97%A8https://www.oschina.net/search?scope=news&q=%E5%B0%8F%E5%8B%90%E6%8B%89%E9%87%91%E5%B1%B1%E8%B4%B5%E5%AE%BE%E4%BC%9A%E5%BE%AE%E4%BF%A1%E5%BC%80%E6%88%B7%E7%94%B5%E8%AF%9D%E6%8E%A8%E8%8D%90TL262%C2%B7C%EF%BC%AFM%E6%AF%AB%E5%B7%9E%E7%A7%BB%E5%8A%A8https://www.oschina.net/search?scope=news&q=%E7%9A%87%E5%AE%B6%E5%9B%BD%E9%99%85%E5%A8%B1%E4%B9%90%E7%83%AD%E7%BA%BF%E7%94%B5%E8%AF%9D%E5%AE%98%E7%BD%91B2024%C2%B7CN%E5%92%B8%E5%AE%81%E9%AB%98%E6%A0%A1&days=0&onlytitle=0&sort_by_time=0https://search.bilibili.com/all?keyword=%E5%AE%9D%E5%8F%91%E5%A8%B1%E4%B9%90%E5%9C%BA%E5%BE%AE%E4%BF%A1%E5%BC%80%E6%88%B7%E7%94%B5%E8%AF%9D%E5%B9%B3%E5%8F%B0%E3%80%90%E5%AE%98%E7%BD%91%E2%86%92TL262%C2%B7%EF%BC%A3%EF%BC%AF%EF%BC%AD%E3%80%91%E6%99%8B%E5%9F%8E%E5%88%86%E7%AB%99http://dblab.xmu.edu.cn/?s=%E9%99%95%E8%A5%BF%E5%BB%B6%E5%AE%89%E5%93%AA%E9%87%8C%E8%83%BD%E7%8E%A9%E5%BA%84%E5%92%8C%E9%97%B2%E7%BD%91%E5%9D%80TL262.%EF%BC%A3%EF%BC%AF%EF%BC%AD%E9%BB%84%E7%9F%B3%E5%8D%AB%E8%AE%A1%E5%A7%94http://iias.tsinghua.edu.cn/search/%E9%91%AB%E7%99%BE%E5%88%A9%E5%A8%B1%E4%B9%90%E4%B8%BB%E7%AE%A1%E5%AE%98%E7%BD%91TL262%EF%BC%8E%EF%BC%A3%EF%BC%AF%EF%BC%AD%E4%B8%89%E4%BA%9A%E4%BA%A4%E9%80%9A

0 回复 有任何疑惑可以回复我~
收起回答
qq_等下一个雨天_0
2018-06-11

break on deptno skip 1

0 回复 有任何疑惑可以回复我~
收起回答

举报

0/150
提交
取消
Oracle高级查询
  • 参与学习       62771    人
  • 解答问题       144    个

数据库开发中应用广泛的高级查询，本教程通过大量的案例详细讲解

进入课程

本课相似问答

1 回答相同的sql用sqlplus执行和用pl/sql执行的结果为什么不一样？

2 回答这个sql文件在哪找

1 回答SQL报表功能

3 回答老师所讲的代码中有order by 1 ，​order by 后面不应该是一个字段名吗

4 回答用notepad++get到sqlplus中，出现中文乱码
搜索更多本课相关问答

在PL/SQL客户端，怎么代码实现 break on deptno skip 1

我要回答 关注问题
意见反馈 帮助中心 APP下载
官方微信