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
137
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
144
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
113
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
315
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
161
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
303
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
93
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
392
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
152
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
166
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
320
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
316
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
305
Total:
5601
Previous
225
226
227
228
229
Next
Go
