Selecting from a Table

Very Basic Syntax

SELECT <column_name> [,<column_name>] ...
FROM <table_name> [,<table_name>] ...
WHERE <condition>;

Example

SQL> select * from emp;

     EMPNO ENAME      JOB	       MGR HIREDATE	    SAL       COMM     DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
      7369 SMITH      CLERK	      7902 17-DEC-80	    800			   20

      7499 ALLEN      SALESMAN	      7698 20-FEB-81	   1600        300	   30

      7521 WARD       SALESMAN	      7698 22-FEB-81	   1250        500         30

Example

SQL> select job from emp where sal < 1000;

JOB
---------
CLERK