update scott.emp set sal= ( select sal+300 from scott.emp where empno=7599 ) where empno=7599;
SQL Server2000 源代码
汇集 SQL Server2000 相关的电路原理图、PCB工程文件、单片机/FPGA源代码、数据手册与应用设计方案。
select empno,ename,job from scott.emp where job
select * from scott.emp where job='MANAGER' and sal2000; select * from scott.emp where job!='MANAGER' or sal2000; select *…
select empno 编号,ename 姓名,job 工作,sal 薪水 from scott.emp
select * from scott.emp;
select * from scott.emp where job='MANAGER'; select * from scott.emp where sal=1100; select * from scott.emp w…
select empno,ename,sal,mgr,sal+mgr from scott.emp
select distinct job from scott.emp
select empno,ename,job from scott.emp
select mgr, mgr-7800,sign(mgr-7800) from scott.emp;