SELECT

A SELECT statement gets data from a table. Each table contains rows and columns - you can SELECT some columns and ignore others

• The column names on the select line control which columns you get
• The FROM clause controls which table you access

schema:scott

The table EMP shows the year and the city hosting the Olympic Games.

EMP

ENAME	JOB	SAL
SMITH	CLERK	800
ALLEN	SALESMAN	1600
WARD	SALESMAN	1250
MARTIN	SALESMAN	1250
BLAKE	MANAGER	2850
CLARK	MANAGER	2450
SCOTT	ANALYST	3000
KING	PRESIDENT	5000

The SELECT statement returns results from a table. In this example the table is EMP and the columns are ENAME and JOB.

DROP TABLE EMP;

CREATE TABLE EMP(ENAME INT, JOB VARCHAR(20),SAL INT); INSERT INTO EMP(ENAME,JOB, SAL) VALUES ('SMITH','CLERK',800); INSERT INTO EMP(ENAME,JOB, SAL) VALUES ('ALLEN',SALESMAN,1600); INSERT INTO EMP(ENAME,JOB, SAL) VALUES ('WARD',SALESMAN,1250); INSERT INTO EMP(ENAME,JOB, SAL) VALUES ('MARTIN',SALESMAN,1250); INSERT INTO EMP(ENAME,JOB, SAL) VALUES ('BLAKE',MANAGER,2850); INSERT INTO EMP(ENAME,JOB, SAL) VALUES ('CLARK',MANAGER,2450); INSERT INTO EMP(ENAME,JOB, SAL) VALUES ('SCOTT',ANALYST,3000); INSERT INTO EMP(ENAME,JOB, SAL) VALUES ('KING',PRESIDENT,5000);

SELECT ENAME, JOB FROM games

See also:

• SELECT Tutorial - practice using the SELECT command
• SELECT ... WHERE - the WHERE clause allows you to get some rows but not others