/SQL/Select even number id data from table

Select even number id data from table

Sql Server we can use %

select * from orders where ID % 2 = 0;

This can be used in both Mysql and oracle. It is more affection to use mod function that %.

select * from orders where mod(ID,2) = 0

Source: stackoverflow.com

Similar codes

1 vote166 views1 answer
Xampp import sql file command line
SQL
0 vote176 views2 answers
Mysql get routine parameter list
SQL
1 vote169 views1 answer
Oracle sql listagg
SQL
0 vote218 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
1 vote177 views1 answer
Tsql find foreign key references
SQL
0 vote175 views1 answer
Oracle last connection
SQL
1 vote166 views1 answer
Reutrn string after character sql
SQL
0 vote233 views1 answer
Php insert null mysql
SQL
0 vote161 views1 answer
How to define a save method in ruby for sql databases
SQL
0 vote172 views1 answer
Sql show all users
SQL