Exercise 1 (Retrieving Data)

1. Select employee numbers, employee names from employee table.

2. Select employee numbers grater than 1010.

3. Select employee number, employee name who draws more than 2000 as the Salary.

4. Select employee number, sal, comm for department 20.

5. Select employee names who were getting salary greater than 1500.

6. Select all the employees whose job = 'CLERK'.

7. Select all the employees whose job = 'CLERK' and salary > 2000.

8. Select employee number, name who works in deptno 30 and name starts with 'K

9. Select all the columns from employee table.

10. Select employee number, name, sal, comm who works in deptno 10, salary greater than 2000 and comm less than 250.