/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

15 votes208 views5 answers
Show tables in oracle
SQL
1 vote172 views1 answer
SQL: merging multiple row data in string
SQL
12 votes163 views4 answers
How to take database dump in postgresql
SQL
0 vote161 views1 answer
Mysql select where field like in list
SQL
6 votes185 views4 answers
Mysql group by month
SQL
1 vote179 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote173 views1 answer
Code to move ietms from one table to another myswl
SQL
0 vote250 views2 answers
Search stored procedures by name
SQL
1 vote211 views1 answer
Sql select contem uma palavra
SQL
0 vote196 views1 answer
Sql basic commands
SQL