DBstar+SQL 源代码

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 ;

create table scott.test as ( select distinct empno,ename,hiredate from scott.emp where empno>=7000 );

insert into scott.emp(empno,ename,hiredate) (select empno+100,ename,hiredate from scott.emp where empno>=6999 )…

use rsgl go select main.main_id,isnull(main.name,''),isnull(main.sex,''),isnull(main.mz,''),isnull(main.born,''), isnu…