Learning, Free job alert & More
You must be able to answer these SQL Interview Questions if you are applying for Data Engineer position at Deloitte. These SQL Interview Questions were recently asked. Read More SQL Interview Questions Write a query to retrieve the top 3 highest salaries from an employee table. See the code here: https://www.db-fiddle.com/f/o2rrtZXupmq93WtHZKyXaG/0 Explain the difference between … Read more
1661 Average Time of Process per Machine: This is a really interesting question where we write a compact code of 1 line which is equivalent to multiline CTE code. Read more Company: MAANG Difficulty: Easy Source: LeetCode SQL Interview Question Q. 1661 Average Time of Process per Machine View code on DB Fiddle Solution Solution1 Explanation To … Read more
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
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
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