check if row number is odd or even

[kani98]

Is there a way for me to check if a specific row in a table is odd or even? Thanks.

[Hesham Amin]

Do you want to check for the ID of the PK column or the order of the record? in the first case: Select *,case (ID % 2) when 1 then 'Odd' Else 'Even' End from items in the second case (SQL Server 2005 only): Select *,case (row_number() over (order by ID) % 2) when 1 then 'Odd' Else 'Even' End from items

---

Hesham A. Amin blog