select empno,ename,job from scott.emp
select empno,ename,job from scott.emp where job='MANAGER'
Select * from scott.emp;
select empno,ename,job from scott.emp
select * from scott.emp where job=¡®MANAGER¡¯
select ename,sal,sal+300 from scott.emp;
select empno emp_id,sal from scott.emp;
select empno AS "emp_id",sal from scott.emp;
select empno||' '||ename from emp;
select empno,'''s name is',ename from emp;
select distinct job from emp;
desc scott.emp;
select * from emp where sal<1600;
SELECT last_name, job_id, department_id
FROM employees
WHERE last_name = 'WHALEN';
select * from scott.emp where job='MANAGER';
select * from scott.emp where sal=1100;
select * from scott.emp where job!='MANAGER';
select * from scott.emp where sal!=1100;
select * from scott.emp where job^='MANAGER';
select * from scott.emp where sal^=1100;
select * from scott.emp where job<>'MANAGER';
select * from scott.emp where sal<>1100;
select * from scott.emp where sal<2000;
select * from scott.emp where job<'MANAGER';
select * from scott.emp where sal>2000;
select * from scott.emp where job>'MANAGER';
select * from scott.emp where sal<£½2000;
select * from scott.emp where job<£½'MANAGER';
select * from scott.emp where sal>=2000;
select * from scott.emp where job>='MANAGER';
select * from scott.emp where sal in (2000,1000,3000);
select * from scott.emp where job in ('MANAGER','CLERK');
select * from scott.emp where sal not in (2000,1000,3000);
select * from scott.emp where job not in ('MANAGER','CLERK');
select * from scott.emp where sal between 2000 and 3000;
select * from scott.emp where job between 'MANAGER' and 'CLERK';
select * from scott.emp where sal not between 2000 and 3000;
select * from scott.emp where job not between 'MANAGER' and 'CLERK';
select * from scott.emp where job like 'M%';
select * from scott.emp where job like 'M__';
select * from scott.emp where job not like 'M%';
select * from scott.emp where job not like 'M__';
select * from scott.emp where sal is null;
select * from scott.emp where job is null;
select * from scott.emp where sal is not null;
select * from scott.emp where job is not null;
SELECT employee_id, last_name, job_id
FROM employees
WHERE job_id LIKE '%SA\_%' ESCAPE '\';
select * from scott.emp where job='MANAGER' and sal<>2000;
select * from scott.emp where job<>'MANAGER' or sal<>2000;
select * from scott.emp where not job>='MANAGER';
SELECT *FROM emp ORDER BY sal ;
SELECT *FROM emp ORDER BY sal desc ;
评论0