Computer Science, asked by vishveshr, 3 months ago

Display the names of employees who earn highest salary in their respective jobs.​

Answers

Answered by RehanAk73
1

Answer:

Explanation:

Display the names of employees who earn highest salary in their respective job groups. Select * from emp e where sal in(select max(sal) form emp group by having e. job=job).

Previous Question
Next Question
Similar questions
Math, 1 month ago
1. Find the estimated quotient for 843 = 26, taking each number correct to the nearest 10​...
English, 1 month ago
Form sentences of your own with the following verbs look, use​...
Environmental Sciences, 1 month ago
why can plants survive during high speed winds without breaking​...
Geography, 3 months ago
Explain the significance of ozone gas present in the atmosphere to the living beings.​
Biology, 3 months ago
A protein has a concentration of 20 micro meters, and tryptophant (E=55000) and 2 tyrosines (E=1490)? What is its absorbance?​
Physics, 9 months ago
In a vernier calipers, n duisions Vernier scale coincide with (N-1) Divisions of Main scale (in which one division represents Imm). The Vernier constant is (cm) .​
Chemistry, 9 months ago
give an activity to show a chemical equation and give corresponding balanced chemical equation.
Chemistry, 9 months ago
A metal Ribbon burns in air with bright white light and forms a white powder .the metallic oxide would be acidic or basic in nature?