Page 1 of 2

Meesho just conducted a Hiring Drive — and Guess What?

They asked some tricky SQL questions to test real problem-solving skills.

👉 The big question is:

Are YOU ready to crak them and Prove you are Job Ready 💼✨

Take the challenge, test your SQL skills, and see if you’ve got what it takes to ace interviews at top companies like Meesho!

Name

Email

Phone Number

Q1 . How do you get the top 3 highest-paid employees from 'Employees' (Select Option As per "MySQL/Postgres" Standard)

SELECT * FROM Employees ORDER BY salary DESC LIMIT 3;

SELECT TOP 3 * FROM Employees ORDER BY salary ASC;

SELECT * FROM Employees WHERE ROWNUM <= 3 ORDER BY salary DESC;

SELECT * FROM Employees ORDER BY salary DESC FETCH FIRST 3 ROWS ONLY;

Q2. Find customers who placed more than 5 Orders ?

https://storage.tally.so/f4c4a2e1-3500-4f60-8da4-6f28dec390fb/Screenshot-2025-09-18-at-8.51.26-PM.png

https://storage.tally.so/4afa8c84-35d9-44e1-81fd-90b95bbe8959/Screenshot-2025-09-18-at-8.51.45-PM.png

https://storage.tally.so/15a5d811-ec92-4f80-a1e0-67b6391647e8/Screenshot-2025-09-18-at-8.54.54-PM.png

https://storage.tally.so/3a228c46-2d76-4539-9bbf-5d8922418236/Screenshot-2025-09-18-at-8.55.11-PM.png

Q3. Which query finds customers who spent more than Rs. 10,000 in total orders?

https://storage.tally.so/ba61aeae-05c9-47b1-87a8-0a830cd591b8/Screenshot-2025-09-18-at-9.59.32-PM.png

https://storage.tally.so/1f854572-f27f-49d0-86bc-ea15e036562d/Screenshot-2025-09-18-at-9.59.54-PM.png

https://storage.tally.so/31e2b602-5e05-4d9a-b3b0-1b25e6207778/Screenshot-2025-09-18-at-10.00.08-PM.png

https://storage.tally.so/1f6d7f27-5a4f-4b6c-895a-8e086de4def5/Screenshot-2025-09-18-at-10.01.02-PM.png

Q.4 Find Customers Who Bought All Products
You have two tables:

Customers(cust_id, cust_name)

Orders(order_id, cust_id, product_id)

Products(product_id, product_name)

Write a query to find customers who have purchased all products available in the Products table

Q.4 Find Customers Who Bought All Products You have two tables:

https://storage.tally.so/f8cdce36-63f3-471a-b69b-ca01945939f7/Screenshot-2025-09-18-at-10.04.28-PM.png

https://storage.tally.so/1907713e-6a79-4ac8-8d9d-a29885863e15/Screenshot-2025-09-18-at-10.04.49-PM.png

https://storage.tally.so/a0ecd1b6-84fc-4128-a47c-0af1d892c7f2/Screenshot-2025-09-18-at-10.05.07-PM.png

Both A and C

Q5. Find the Second Highest Salary (without using LIMIT or TOP directly)
You have a table Employees(emp_id, name, salary).
Write a query to find the second highest salary in the company.

Q5. Find the Second Highest Salary (without using LIMIT or TOP directly)You have a table Employees(emp_id, name, salary).Write a query to find the second highest salary in the company.

https://storage.tally.so/97b7fb09-cad9-4bc5-953c-c297514f34fe/Screenshot-2025-09-18-at-10.06.51-PM.png

https://storage.tally.so/e725afb5-8358-4eaf-b32f-0bf495c793c6/Screenshot-2025-09-18-at-10.07.11-PM.png

https://storage.tally.so/b53a3f8a-4c41-43a1-9047-f54431e83185/Screenshot-2025-09-18-at-10.07.24-PM.png

https://storage.tally.so/30f25040-2eb6-4b93-a875-3577a961ff42/Screenshot-2025-09-18-at-10.07.39-PM.png