How to get alternate records in SQL?

Question

Can anyone tell me how to get alternate records in SQL?

Answer 1

You can use the following query to get the alternate even-numbered records in SQL:

 

SELECT *

FROM table_name

WHERE column_name % 2 = 0

You can use the following query to get the alternate odd-numbered records in SQL:

SELECT *

FROM table_name

WHERE column_name % 2 = 1

If you are interested in SQL, then take up this SQL certification online course by Intellipaat that offers instructor-led training, certification, and job assistance.