limit

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

Find the most common value (mode) in a specific column.

by
Find the most common value (mode) in a specific column

This question was asked in Interview at black rock. Read more Company: BlackRock CTC: 26LPA Source: LinkedIn SQL Interview Question Q. Find the most common value (mode) in a specific column. See this code on db-fiddle Solution Explanation We have selected ProductName along with the count of rows as Frequency, grouping the data by ProductName. To display … Read more