subquery

Write a query to identify the employee(s) whose salary is closest to the average salary of the company.

by

This question was asked in Interview at black rock. The open position had a CTC of 26 LPA. Read more Company: BlackRock CTC: 26LPA Source: LinkedIn SQL Interview Question Q. Write a query to identify the employee(s) whose salary is closest to the average salary of the company see this code on db-fiddle Solution Explanation In this … Read more

Identify employees who have never received a performance review.

by
Identify employees who have never received a performance review.

This question was asked in Interview at black rock. Read more Company: BlackRock CTC: 26LPA Source: LinkedIn SQL Interview Question Q. Identify employees who have never received a performance review. See this code on db-fiddle Solution Explanation It is a very Streight forward solution where a subquery is utilized to filter the employee records. Subquery contains the … Read more

Write a query to retrieve the first order placed by each customer.

by

This question was asked in Interview at black rock. Read more Company: BlackRock CTC: 26LPA Source: LinkedIn SQL Interview Question Q. Write a query to retrieve the first order placed by each customer. see this code on db-fiddle Solution Solution 1 Solution 2 Solution 3 Explanation While there are multiple ways to solve this problem, but most … Read more

Exit mobile version