/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

4 votes275 views1 answer
What are the data types in sql
SQL
1 vote349 views2 answers
Copy table in sql
SQL
0 vote250 views1 answer
Mysql workbench search all tables
SQL
0 vote280 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
5 votes300 views2 answers
Sql constraint check value in list
SQL
0 vote280 views1 answer
Mysql subtract month from timestamp
SQL
0 vote279 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
1 vote291 views1 answer
Retrieve meaning
SQL
0 vote297 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
-1 vote281 views1 answer
Module operator in oracle sql
SQL