/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 vote349 views1 answer
Mysql return text after a final full stop
SQL
0 vote336 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
0 vote428 views1 answer
Mysql get nested records
SQL
0 vote346 views2 answers
Select columns from 2 tables with foreign key
SQL
1 vote320 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
0 vote369 views1 answer
Influxdb list all tags for a measurement
SQL
10 votes335 views4 answers
Sql pagination
SQL
0 vote370 views1 answer
Sql: extract day text from datetime value
SQL
3 votes288 views2 answers
Mysql sum with condition
SQL
0 vote350 views1 answer
Sql ignore
SQL