SQL+Server2000 源代码

汇集 SQL+Server2000 相关的电路原理图、PCB工程文件、单片机/FPGA源代码、数据手册与应用设计方案。

收录资源 500 份全站深度检索

共匹配 500 份工程资源 · 第 29 / 50 页

源码文件

select emp.empno,emp.ename,emp.job,emp.sal from scott.emp where sal in (select sal from scott.emp where ename='WARD');

源码文件

(select deptno from scott.emp) intersect (select deptno from scott.dept);

源码文件

select emp.empno,emp.ename,emp.job,emp.sal from scott.emp where sal >all(select sal from scott.emp where job='MANAGER');

源码文件

select emp.empno,emp.ename,emp.job,emp.sal from scott.emp,scott.dept where exists (select * from scott.emp where scott.emp.d…

源码文件

select emp.empno,emp.ename,emp.job,emp.sal from scott.emp where sal =some(select sal from scott.emp where job='MANAGER');

源码文件

select emp.empno,emp.ename,emp.job,emp.sal from scott.emp where sal >any(select sal from scott.emp where job='MANAGER');

源码文件

select emp.empno,emp.ename,emp.job,emp.sal from scott.emp where sal>=(select sal from scott.emp where ename='WARD');

源码文件

(select deptno from scott.dept) minus (select deptno from scott.emp);

源码文件

delete from scott.test where empno>=7500 and empno

源码文件

truncate table scott.test ;