--工资排序 头十个人
select top 10 empno,ename,sal
from emp
order by sal desc
--排名在第六到第十的
with t as(select top 10 row_number() over (order by sal desc)xh,ename,sal
from emp
order by sal desc)
select *
from t
where xh>=6 and xh<=10
--寻找随机数产生函数
select rand()
as '随机数'
select cast( floor(rand()*100) as int)
select cast(ceiling(rand() * 100) as int)
--哪个部门提供了anlyst clerk manager三个职位
select distinct job
from emp
--包含这三个职位的部门
select distinct dname
from emp join dept
on emp.DEPTNO = dept.DEPTNO
where job in ('analyst','clerk','manager')
--每个职位都包含的部门
(select distinct dname
from emp join dept
on emp.DEPTNO = dept.DEPTNO
where job in ('analyst'))intersect(select distinct dname
from emp join
select top 10 empno,ename,sal
from emp
order by sal desc
--排名在第六到第十的
with t as(select top 10 row_number() over (order by sal desc)xh,ename,sal
from emp
order by sal desc)
select *
from t
where xh>=6 and xh<=10
--寻找随机数产生函数
select rand()
as '随机数'
select cast( floor(rand()*100) as int)
select cast(ceiling(rand() * 100) as int)
--哪个部门提供了anlyst clerk manager三个职位
select distinct job
from emp
--包含这三个职位的部门
select distinct dname
from emp join dept
on emp.DEPTNO = dept.DEPTNO
where job in ('analyst','clerk','manager')
--每个职位都包含的部门
(select distinct dname
from emp join dept
on emp.DEPTNO = dept.DEPTNO
where job in ('analyst'))intersect(select distinct dname
from emp join