Learning, Free job alert & More
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
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
What is SQL Natural Join? Natual Join is a type of join in SQL which combines row from 2 tables based on common column which has same name and datatype. It automatically matches the 2 columns and eliminates the duplicate column. read more Example Database CustomerID FirstName LastName Email City 1 John Doe john.doe@example.com New … Read more
This question was asked in Interview at black rock. Read more Company: BlackRock CTC: 26LPA Source: LinkedIn SQL Interview Question Q. Display the cumulative percentage of total sales for each product. sale_id product_id sales 1 101 500.00 2 102 300.00 3 103 200.00 4 101 400.00 5 102 600.00 6 103 800.00 7 104 1000.00 … Read more
