/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

0 vote319 views1 answer
Get relation data in mysql using query to excel
SQL
1 vote336 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote319 views1 answer
Pl sql search in all packages
SQL
0 vote333 views1 answer
Mysql change innodb to myisam
SQL
0 vote343 views2 answers
While mysql
SQL
0 vote342 views1 answer
How to generate ids in sql
SQL
1 vote326 views4 answers
Alter schema sql
SQL
4 votes334 views4 answers
Rollback in sql
SQL
25 votes320 views3 answers
Mysql command show tables
SQL
0 vote316 views1 answer
Sql query interview questions githu
SQL