Learning, Free job alert & 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 …
This question was asked in Interview at black rock. Read more Company: BlackRock CTC: 26LPA Source: LinkedIn SQL Interview Question Q. Display all months where sales exceeded the average monthly sales see …
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 …
Company: BlackRock CTC: 26LPA Source: Linked Post Q. Retrieve the name of the manager who supervises the most employees. Solution: Explanation: Here, we want to find out the manager who supervises …
Query: SELECT product_id FROM sales GROUP BY product_id HAVING COUNT(DISTINCT region_id) = (SELECT COUNT(*) FROM regions); Explanation: We need to find products that have been sold in all regions. This …