/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 vote195 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
0 vote190 views1 answer
Run postgresql dump to csv
SQL
0 vote249 views1 answer
Sql server rtrim everything after character
SQL
0 vote280 views1 answer
How to login to mysql in homestead
SQL
0 vote188 views1 answer
Sql server remove enter from string
SQL
0 vote235 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote194 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote187 views1 answer
Change permission to database mysql
SQL
3 votes194 views4 answers
Show databases in sql server
SQL
0 vote175 views1 answer
Mariadb set vertical output format
SQL