How can you select all the even number records from a table? All the odd number records?

Question

After you learned all about the SELECT command answer me that question ❓

Answer 1

I having the answer, but I'll letting you try.

Answer 2

If column then we can use MOD function if records needed then using row number we can find I guess. let me know the answer if I'm wrong.

Answer 3

So, thank you very much MANASA for your try, your answer is wrong.
To select all the even number records from a table:

Select * from table where id % 2 = 0

To select all the odd number records from a table:

Select * from table where id % 2 != 0

Answer 4

For Manasa, The SQL MOD() function returns the remainder from a division.

Answer 5

hi

Answer 6

Okay Thanks

Answer 7

You're welcome Manasa