Query to fetch every alternate records from a table in SQL?
We can fetch every alternate records and we can fetch by every odd and even row numbers. Below are the query for odd and even number:-
(1)Every even row number by using below query:-
select column1 from(select column1,column2 from table_name) where mod(rowno,2)=0
(2)Every odd row number by using below query:-
select column1 from(select column1,column2 from table_name) where mod(rowno,2)=1 | |