SQL Tips get odd records Interview question #sqltips #sql #interview

ROW_NUMBER AS row_num: This part assigns a sequential number to each row in the result set based on the specified ordering by name.

Filtering for Odd Rows: The WHERE row_num modulo 2 not equal to 0 condition filters for rows where the row_num value is odd.

Result: This will yield the same output as before, but with the column name changed to row_num. You will still retrieve all the odd-numbered records from the employees table.