Sql Certificate 简明教程

SELECT ename, (sysdate - hiredate)
FROM emp;

SELECT sysdate - hiredate
FROM emp
WHERE empno=7369;

SELECT 'Tutorial''s Point compiles technical tutorials' FROM DUAL;

 Name                                      Null?    Type
 ----------------------------------------- -------- -------------

 TRAINING_ID                               NOT NULL NUMBER(5)
 TRAINING_LOCATION                                  NUMBER(7,2)
 START_DATE                                         DATE
 END_DATE                                           DATE

SELECT col1, col2
FROM tab1
ORDER BY col1;

SELECT col1,col2
FROM tab1
WHERE col1 = 'A'
ORDER BY col2 DESC, col1;

SELECT col1, col2
FROM  tab1
ORDER BY col1,col2
WHERE col2 = 'B';

SELECT ename, deptno, sal
FROM emp;

SELECT empno, ename, job
FROM emp
WHERE ename like '_ith%';

SELECT ename, deptno, sal, comm
FROM emp
WHERE job = 'SALES'
AND hiredate = ”01-JAN-97”;

SELECT first_name, last_name, dept_id
FROM employees
WHERE hire_date LIKE '%98';

SELECT first_name, last_name
FROM employees
WHERE last_name BETWEEN 'B%' AND 'E%';

SELECT employee_id, last_name, first_name, salary, manager_id
FROM employees
WHERE manager_id IN (200,100,300);

SELECT first_name, salary,
salary + (salary *0.25) "INCREASED_SALARY"
FROM employees
WHERE increased_salary >30000;

SELECT first_name, dept_id, salary
FROM employees
WHERE dept_id = 100 AND (salary = 2000 OR salary = 4000)
AND job_id <> '';

SELECT emp_id
FROM employees
WHERE salary>=20000*0.25
ORDER BY salary*0.25 DESC;

 Name                                      Null?    Type
 ----------------------------------------- -------- -------------

 TRAINING_ID                               NOT NULL NUMBER(5)
 TRAINING_LOCATION                                  NUMBER(7,2)
 START_DATE                                         DATE
 END_DATE                                           DATE

TRAINING_ID      START_DATE                      TRAINING_COST
------ ---------------- -------------------------------------------------
11 	                 01-JAN-10 			1000
22 		  01-FEB-10 			2000
33 		  01-MAR-10 			3000

SELECT emp_id, first_name
FROM employees
ORDER BY dept_id;

SELECT emp_id, first_name “EmpName”
FROM employees
ORDER BY "EmpName";

SELECT last_name, job_id, department_id, hire_date
FROM employees
ORDER BY 2;

SELECT emp_id, first_name, last_name FROM employees WHERE job_id....;

SELECT first_name, last_name, employee_id, salary
FROM employees
WHERE employee_id = &eid;

SELECT first_name, last_name, &&prompt_col
FROM employees
ORDER BY &&promp_col;

DEFINE eid = 117

SELECT first_name, last_name, employee_id, salary
FROM employees
WHERE employee_id = &eid;

SELECT ename || q'{'s salary is }' || sal
AS "Salary"
FROM emp;

SELECT ename, sal, deptno
FROM emp
WHERE sal/10 > deptno*10;

SELECT ename, deptno, sal
FROM emp
WHERE job=CLERK;

SELECT ename, deptno, sal
FROM emp
WHERE sysdate-hiredate > 100;