SQL Odd-Numbered Rows | Dataford Interview Questions

How would you write a SQL query to extract odd-numbered rows from a table?

Assume row_number stores the row number to evaluate. Return only rows with odd values and sort them by row_number in ascending order.

Output

records

Column	Type	Description
record_idPK	INT	Unique identifier for the stored record
row_number	INT	Number used to determine whether the row is odd or even
row_label	VARCHAR(100)	Descriptive label for the record

Your question is SQL Odd-Numbered Rows. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

How would you write a SQL query to extract odd-numbered rows from a table?

Assume row_number stores the row number to evaluate. Return only rows with odd values and sort them by row_number in ascending order.

records

Column	Type	Description
record_idPK	INT	Unique identifier for the stored record
row_number	INT	Number used to determine whether the row is odd or even
row_label	VARCHAR(100)	Descriptive label for the record

Your question is SQL Odd-Numbered Rows. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.