4.7K
AS๐ก SQL Interview Question:
๐ How do you display ODD-numbered records from a table in SQL?
This is a common SQL interview question to test your understanding of ROW numbering and filtering logic.
Hereโs the clean SQL query ๐
SELECT *
FROM (
SELECT e.*,
ROW_NUMBER() OVER (ORDER BY employee_id) AS rn
FROM employees e
) t
WHERE rn % 2 = 1;
๐ฏ Explanation:
ROW_NUMBER() assigns a sequential number to each row
ORDER BY employee_id defines the row order
% 2 = 1 filters only odd-numbered rows
Subquery is required because window functions cannot be directly used in WHERE
Useful for pagination and alternate row selection
โ
Perfect for:
โ๏ธ SQL Interviews
โ๏ธ Backend Developers
โ๏ธ Data Analysts
โ๏ธ Java + Spring Boot Learners
โ๏ธ Reporting & Pagination Logic
๐ Save this post for SQL revision
๐ Follow @ashokitschool for more SQL + Java + Full Stack content
#SQLInterviewQuestions #SQLTips #OddRecords #RowNumberSQL #AshokIT
@ashokitschool
