標題: 數(shù)據(jù)庫內(nèi)連接 [打印本頁] 作者: liumei 時間: 2014-4-26 13:23 標題: 數(shù)據(jù)庫內(nèi)連接 1、select "E".ename,"E".deptno,"E".sal,"S".grade
from emp "E"
join salgrade "S"
on "E".sal between "S".losal and "S".hisal
2、select "T".*,"S".grade
from
(select "E".deptno, avg("E".sal) "avg_sal"
from emp "E"
join dept "D"
on "E".deptno = "D".deptno
group by "E".deptno) "T"
join salgrade "S"
on "T"."avg_sal" between "S".losal and "S".hisal
3、select "T".*, "D".dname, "S".grade
from
(select deptno, avg(sal) "avg_sal"
from emp "E"
group by "E".deptno) "T"
join dept "D"
on "T".deptno = "D".deptno
join salgrade "S"
on "T"."avg_sal" between "S".losal and "S".hisal
4、select empno from emp where empno in (select mgr from emp)
select top 1"E".deptno, avg("E".sal) "avg_sal"
from emp "E"
group by "E".deptno
order by "avg_sal" desc
5、select top 3 "T".*, "D".dname,"S".grade
from
(select ename, sal, deptno
from emp
where sal > (select min(sal) from emp)
) "T"
join dept "D"
on "T".deptno = "D".deptno
join salgrade "S"
on "T".sal between "S".losal and "S".hisal
order by sal asc