Answer:
The objective of this exercise is to enable you to understand and SQL relational concepts.
Problem Statement:
Consider the following database and display the worker name wh getting highest salary.
Worker table
+
| ID |
NAME |
DEPT |
SALARY |
DOJ |
BRANCH |
|
101 |
Amit |
Production |
45000.00 |
2018-10-20 |
Bangalore |
| 102 |
Amit |
HR |
70000.00 |
2019-07-02 |
Bangalore |
+
| 103 |
sunita
| Management |
120000.00 |
2019-01-11 |
mysore |
| 105 |
sunita |
IT |
67000.00 |
2018-08-01 |
mysore |
| 106 |
mahesh |
Civil |
145000.00 |
2019-09-20 |
Mumbai |