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
201
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
201
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
129
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
382
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
194
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
333
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
126
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
479
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
203
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
189
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
368
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
406
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
395
Total:
5601
Previous
225
226
227
228
229
Next
Go
