List the name, salary of the employees who are clerks. Employee Table with data EMPNO ENAME MGR
Fantastic news! We've Found the answer you've been seeking!
Question:
- List the name, salary of the employees who are clerks.
Employee Table with data
EMPNO | ENAME | MGR | HIREDATE | SAL | DEPTNAME |
1 | SMITH | 3 | 12/17/1980 | 800.00 | BANKING |
2 | ALLEN | 4 | 2/20/1981 | 1600.00 | INSURANCE |
3 | WARD | 2/22/1981 | 1250.00 | BANKING | |
4 | JONES | 4/2/1981 | 2975.00 | INSURANCE | |
5 | MARTIN | 4 | 9/28/1981 | 1250.00 | INSURANCE |
6 | BLAKE | 7 | 5/1/1981 | 2850.00 | SERVICES |
7 | CLARK | 6/9/1981 | 2450.00 | SERVICES | |
8 | SCOTT | 4 | 12/9/1982 | 3000.00 | INSURANCE |
9 | KING | 3 | 11/17/1981 | 5000.00 | BANKING |
10 | TURNER | 4 | 9/8/1981 | 1500.00 | INSURANCE |
11 | ADAMS | 3 | 1/12/1983 | 1100.00 | BANKING |
12 | JAMES | 7 | 12/3/1981 | 950.00 | SERVICES |
13 | FORD | 4 | 12/3/1981 | 3000.00 | INSURANCE |
14 | MILLER | 4 | 1/23/1982 | 1300.00 | INSURANCE |
Related Book For
Fundamentals Of Database Systems
ISBN: 9780133970777
7th Edition
Authors: Ramez Elmasri, Shamkant Navathe
Posted Date: