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
185
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
185
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
124
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
365
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
184
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
324
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
116
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
444
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
188
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
185
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
351
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
389
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
376
Total:
5601
Previous
225
226
227
228
229
Next
Go
