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

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);

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