Here:
SELECT *
FROM (SELECT ROW_NUMBER() OVER(ORDER BY <column_name>) AS ROW_ID, *
FROM <table_name>) AS MyTable WHERE ROW_ID%2=0
Books, programming, music, movie, travelling, what else?
Books, programming, music, movie, travelling, what else?
Here:
SELECT *
FROM (SELECT ROW_NUMBER() OVER(ORDER BY <column_name>) AS ROW_ID, *
FROM <table_name>) AS MyTable WHERE ROW_ID%2=0