SQL1999学习笔记

惊梦师兄

于 2014-02-07 22:17:06 发布

阅读量157

点赞数

CC 4.0 BY-SA版权

分类专栏： ORACLE

本文链接：https://blog.youkuaiyun.com/lwpqh/article/details/84524367

ORACLE 专栏收录该内容

11 篇文章

订阅专栏

本文档包含了一系列 SQL 查询练习题，通过复杂的子查询和连接操作来获取特定的数据集，例如找出每个部门中薪资最高的人、计算各部门平均薪资对应的级别等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SQL1999学习

select ename,sal form emp join (select max(sal) max_sal,deptno from emp group by deptno) t on (emp.sal=t.max_sal and emp.deptno=t.deptno);

select deptno,avg_sal,grade from (select deptno,avg(sal) avg_sal from emp group by deptno) t join salgrade s on(t.avg_sal between s.losal and s.hisal)

select deptno,avg(grade) from (select deptno,ename,grade from emp join salgrade s on (emp.sal between s.losal and s.hisal)) t group by deptno

select ename from emp where empno in(select distinct mgr from emp )

select distinct sal from emp where sal not in (select distinct e1.sal from emp e1 join emp e2 on(e1.sal< e2.sal))

select deptno,avg_sal from (select avg(sal) avg_sal,deptno from emp group by deptno) where avg_sal=(select max(avg_sal) from (select avg(sal) avg_sal,deptno from emp group by deptno))