Sunday, October 29, 2017

Find out all even number and all odd number by sql

Find out even number from table 

select number from table where ( num % 2 ) = 0

Find out odd number from table 

select number from table where ( num % 2 )  != 0

No comments:

Post a Comment