|
SELECT
This statement is used to select (some) attributes of all Tuples or Records in one or two Tables.
Syntax ::
SELECT COLUMN 1,COLUMN 2,...,COLUMN X
FROM TABLENAME;
Example 1::
SELECT EMP_ID,ENAME,SAL
FROM EMPLOYEE;
|
Example 2::
SELECT EMP_ID,ENAME,DEPT_NO,DNAME
FROM EMPLOYEE,DEPARTMENT
WHERE DEPT_NO.EMPLOYEE=DEPT_NO.DEPARTMENT;
|
|
