Find Alternate Row - TSQL Query

Find Alternate Row Query

Query - 1

Select ROW_NUMBER () over (Order By MemberID) as RowID,

 * into #temptab FROM Member

 

Select * From #temptab where (rowid%2) <>0

Query - 2

Select  Identity(int,1,1) As Rowid,
        * Into #Temptab from dbo.Member

Select * from #Temptab where (rowid%2)<>0

Result

Drop table #Temptab