/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

2 votes350 views1 answer
Python sql
SQL
5 votes334 views4 answers
Mysql update column with value from another table
SQL
0 vote316 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
1 vote330 views1 answer
How to get the date diff on once field in sql server
SQL
0 vote352 views1 answer
Python dictionary to sql update
SQL
2 votes307 views1 answer
How to check grants on a package in oracle
SQL
0 vote322 views1 answer
How to find the most occuring in SQL
SQL
3 votes332 views1 answer
Start mysql server linux terminal
SQL
20 votes290 views5 answers
Mysql reset auto increment to 1
SQL
1 vote303 views1 answer
Sql find column name like
SQL