文章列表
1.<html>
2.<body>
3.<style>#yinyue{ background:no-repeat; position:absolute; top:100px; left:100px; visibility:inherit;}</style>
4.<div id="yinyue">
5.<object classid="CLSID:6BF52A52-394A-11d3-B153-00C04F79FAA6" id="MusicPlayer" h ...
<html>
<head>
<title>changecolor</title>
</head>
<body>
<div style="width:200px;height:100px;background:maroon;"
onmouseover="changeColor('maroon')">蓝色</div>
<div style="width:200px;height:100px;backgrou ...
1．列出至少有一个员工的所有部门。
select * from dept where deptno in(select distinct deptno from emp);
2．列出薪金比“SMITH”多的所有员工。
select * from emp where sal>(select sal from emp where ename='SMITH');
3．列出所有员工的姓名及其直接上级的姓名。
select ename,(select ename from emp where empno=e.mgr) as mgr from emp e;
4．列出受雇日期早于其直接上级的所有员工。
...