Discover
Questions library
Collections library
Find online teacher
login
Discover
questions library
Find online teacher
login
Popular searches:
if-else
class-diagram
flowchart
Polymorphism
Home
Questions
Questions
Study lists
hamza shaheen Questions
5601 Questions
From the following table, write a SQL query to find those employees who earn highest salary in a department. Return department ID, employee name, and salary
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
212
From the following table, write a SQL query to find those departments managed by 'Susan'. Return all the fields of departments
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
210
From the following tables, write a SQL query to find those employees who work in departments located at 'United Kingdom'. Return first name
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
132
From the following table, write a SQL query to find those employees who earn more than average salary and who work in any of the ‘IT’ departments. Return last name
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
392
From the following table, write a SQL query to find all those employees who earn more than an employee whose last name is 'Ozer'. Sort the result in ascending order by last name. Return first name, last name and salary
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
203
From the following tables, write a SQL query to find those employees who work under a manager based in ‘US’. Return first name, last name
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
337
From the following tables, write a SQL query to find those employees whose salary is greater than 50% of their department's total salary bill. Return first name, last name
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
131
From the following tables, write a SQL query to find those employees who are managers
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
0
495
From the following table, write a SQL query to find those employees who manage a department. Return all the fields of employees table
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
208
From the following table, write a SQL query to find those employees who get such a salary,
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
192
From the following tables, write a SQL query to find those departments, located in the city ‘London’. Return department ID, department name
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
373
From the following table, write a SQL query to find those employees who earn more than the average salary
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
415
From the following table, write a SQL query to find those employees who earn more than the maximum salary of a department of ID 40. Return first name, last name and department ID
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
403
Total:
5601
Previous
225
226
227
228
229
Next
Go
