Asp.Net

Tuesday, 17 September 2013

SQL Server, for selecting even and odd rows

select * from Tbl_Users where USER_ID%2=0(for even rows)
select * from Tbl_Users where USER_ID%2=1(for odd rows)

No comments:

Post a Comment