These are SQL questions of the kind Wipro actually asks — the patterns that keep coming back in Wipro's online tests and technical interview rounds for freshers. My advice: treat this page as a mock test. Attempt every question on paper first, then reveal. If any answer surprises you, the lesson it comes from is linked right below — go read it, then come back.
Wipro SQL query questions
Write a query to find the second highest distinct salary from the employees table using LIMIT and OFFSET (no subquery, no window function).
Asked in
employees6 rows
| emp_id | name | salary |
|---|---|---|
| 1 | Asha | 90000 |
| 2 | Ravi | 85000 |
| 3 | Meera | 85000 |
| 4 | Kiran | 70000 |
| 5 | Zoya | 60000 |
| 6 | Dev | 55000 |
The employees_dup table has duplicate rows for the same email. Write a query to delete the duplicates, keeping only the row with the lowest emp_id for each email.
Asked in
employees_dup5 rows
| emp_id | name | |
|---|---|---|
| 1 | Asha | asha@corp.com |
| 2 | Ravi | ravi@corp.com |
| 3 | Asha R | asha@corp.com |
| 4 | Ravi K | ravi@corp.com |
| 5 | Meera | meera@corp.com |
Write a query to fetch all employees whose emp_id is an even number.
Asked in
employees6 rows
| emp_id | name | salary |
|---|---|---|
| 1 | Asha | 90000 |
| 2 | Ravi | 85000 |
| 3 | Meera | 85000 |
| 4 | Kiran | 70000 |
| 5 | Zoya | 60000 |
| 6 | Dev | 55000 |
How to use this page: Wipro rarely asks a question you've never seen — they ask standard patterns with a twist. Master the pattern in the SQL course lessons, and the twist stops mattering.
Keep practising: SQL Basics, Joins, GROUP BY & HAVING and Subqueries cover what most Wipro SQL rounds test — and the Wipro exam guide covers the rest of their selection process.