4. Selecting ROWS to display: Step 1

Demo

List the data for employees in department 10

SQL

SELECT * FROM emp WHERE deptno = 10;

Output

empno ename job mgr hiredate sal comm deptno
7782 CLARK MANAGER 7839 1993-05-14 2450.00 10
7839 KING PRESIDENT 1990-06-09 5000.00 0.00 10
7934 MILLER CLERK 7782 2000-01-21 1300.00 10

Discussion

Lists everything about the employees in department number 10.

Progress

Proceed to Next step