Affine Analytics Interview Questions | How to fetch only even rows from a table?

Question

Even rows

in progress 2
TheDataMonk 55 years 2 Answers 1285 views Grand Master 0

Answers ( 2 )

  1. swap007
    1
    Reply

    select * from (Select id,row_number() OVER(order by id) as Row_Number from Employee) as e
    where Row_Number % 2 == 0

Leave an answer

Browse
Browse