/SQL/Sql mod even odd

Sql mod even odd

Sql mod even odd

#to check eif id is even
select city from station where mod(id,2) = 0;
#to check eif id is odd
select city from station where mod(id,2) <> 0;

0

Source: tableplus.com

Similar codes

0 vote306 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote335 views1 answer
Psql show db
SQL
0 vote313 views1 answer
Postgresql comandos basicos
SQL
0 vote406 views1 answer
What is common table expression in sql
SQL
0 vote302 views1 answer
Wordpress sql change site url
SQL
0 vote289 views1 answer
Linux upload database to mysql
SQL
0 vote297 views1 answer
Mysql events not work
SQL
3 votes301 views1 answer
Show index table
SQL
2 votes314 views3 answers
How to pass password mysql command line
SQL
1 vote304 views2 answers
DROP TABLes regardless of constraints
SQL

Share