/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 vote189 views2 answers
Sql server select first day of previous year
SQL
2 votes208 views1 answer
Alter table add column and foreign key mysql
SQL
0 vote202 views1 answer
How to connect to xampp sql server on windows cmd
SQL
1 vote203 views1 answer
Update foreign key value in mysql
SQL
0 vote207 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
0 vote181 views1 answer
Backup a table in sql
SQL
1 vote201 views2 answers
Login to mysql
SQL
0 vote221 views1 answer
Add timestamp column to existing table t-sql
SQL
0 vote188 views1 answer
Drop check command
SQL
1 vote187 views1 answer
Scaffold mysql database
SQL