SQL Interview Questions | Alternate Rows

You have data of people having applied for a lottery ticket. The data consists of their name and ticket number. You have to choose winners by selecting the people present in the alternate rows (first winner starting from row number 3). Write a query to make things easy to select the winners. (Hint- Choose alternate … Continue reading SQL Interview Questions | Alternate Rows