Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 486
|
<consider the="" following="" relation:=""
Works (emp name, company name, salary)
Here, emp_name is primary key. Consider the following SQL query
Select emp name
From works T
Where salary > (select avg (salary)
from works S
where T.company _ name = S.company _name)
The above query is for following :
Works (emp name, company name, salary)
Here, emp_name is primary key. Consider the following SQL query
Select emp name
From works T
Where salary > (select avg (salary)
from works S
where T.company _ name = S.company _name)
The above query is for following :
|
Find the highest paid employee who earns more than the average salary of all employees of his company
|
|
|
Find the highest paid employee who earns more than the average salary of all the employees of all the companies.
|
|
|
Find all employees who earn more than the average salary of all employees of all the companies.
|
|
|
Average salary of all employees of their company.
|
Question 486 Explanation:
Correct Answer: A
Question 486 Explanation: