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
145
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
148
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
115
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
322
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
165
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
307
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
97
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
400
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
156
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
169
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
325
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
330
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
318
Total:
5601
Previous
225
226
227
228
229
Next
Go
