/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 vote348 views2 answers
Csv into data postgres
SQL
1 vote371 views1 answer
Sql check roles
SQL
8 votes345 views3 answers
Mysql alter table add index
SQL
7 votes338 views1 answer
Query delete duplicates
SQL
0 vote371 views1 answer
Groupby sort sql hive
SQL
-1 vote336 views1 answer
Sql getdate date only
SQL
2 votes335 views1 answer
Get first 3 letters name in sql
SQL
6 votes362 views2 answers
Stored procedure to delete data from table in mysql
SQL
18 votes342 views3 answers
Mysql number format
SQL
0 vote348 views1 answer
Mysql workbench indent formatting
SQL