| Write a query to get all even and odd number if we have some id column?
Below is the query to get all even number of records from sql table.
SELECT * FROM TABLE_NAME WHERE ID % 2 = 0
And belos is the query to get all odd number of records from table.
SELECT * FROM TABLE_NAME WHERE ID % 2 != 0 | | |