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:
Subscribe
Login
0 Comments