/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 vote214 views1 answer
TSQL function split string
SQL
0 vote202 views1 answer
Mysql root localhost run
SQL
5 votes165 views2 answers
Oracle list columns schema
SQL
0 vote171 views1 answer
Java spring boot connect to sql server
SQL
0 vote190 views1 answer
How to get specific salary in sql
SQL
2 votes206 views1 answer
Query to find table size in oracle 12c
SQL
0 vote173 views1 answer
Strat with in sql
SQL
0 vote200 views1 answer
Mysql cast null to string
SQL
1 vote202 views1 answer
Tsql update datetime
SQL
0 vote189 views1 answer
Sql server select ignore dupplicates
SQL