/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 vote125 views1 answer
Test sql query
SQL
1 vote122 views1 answer
Sql select contem uma palavra
SQL
4 votes82 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
1 vote115 views1 answer
How to delete record sql delphi
SQL
16 votes133 views6 answers
Insert sql
SQL
0 vote133 views1 answer
Setval postgres example table id
SQL
1 vote131 views1 answer
Install postgresql on raspberry pi
SQL
0 vote130 views1 answer
Sql cheetsheet
SQL
0 vote83 views1 answer
How to fetch highest score in minimum time using mysql
SQL
5 votes129 views3 answers
Oracle first day of last year
SQL