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 worked as a ‘Sales Representative’ in the past
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
413
From the following table, write a SQL query to find any existence of those employees whose salary exceeds 3700. Return first name, last name and department ID
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
250
From the following table, write a SQL query to find total salary of those departments where at least one employee works
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
181
Write a query to display the employee id, name ( first name and last name ) and the job id column with a modified title SALESMAN for those employees whose job title is ST_MAN and DEVELOPER for whose job title is IT_PROG
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
193
Write a query to display the employee id, name ( first name and last name ),
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
234
Write a query to display the employee id, name ( first name and last name )
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
243
From the following table, write a SQL query to find all those departments where at least one or more employees work.Return department name
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 employees whose department located at 'Toronto'
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
285
From the following table, write a SQL query to find those employees whose salary is lower than any salary of those employees whose job title is 'MK_MAN'
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
172
From the following table, write a SQL query to find those employees whose salary is lower than any salary of those employees whose job title is ‘MK_MAN’
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
357
From the following table, write a SQL query to find those employees whose salary is more than any salary of those employees whose job title is ‘PU_MAN’. Exclude job title ‘PU_MAN’
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
380
From the following table, write a SQL query to find those employees whose salary is more than average salary of any department. Return employee ID, first name, last name, job ID
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
126
From the following table, write a SQL query to find those employees whose designation is the same as the employee whose ID is 169
Sql programming
2022-05-18
Answers
30
Question
40
Followers
30
0
1
126
Total:
5601
Previous
227
228
229
230
231
Next
Go