SQL Integer devision

-- When performing division operations on integer values, 
-- the results will always be integers and the results 
-- may not always be what you expect.

SELECT 1 / 2; --> Result: 0
SELECT 1.0 / 2; --> Result: 0.5
SELECT CAST(1 AS REAL) / 2; --> Result: 0.5
SELECT 17 / 5; --> Result: 3
SELECT 17 % 5; --> Result: 2

-- Remember, these are integers and so the result will 
-- be an integer and 1.0 is not an integer.

Similar codes

0 vote177 views1 answer
Get yesterday date ISO in psql
SQL
3 votes203 views1 answer
Oracle list privileges
SQL
0 vote187 views1 answer
How to import sqlite driver class in java using maven
SQL
0 vote260 views1 answer
Jooq replace
SQL
2 votes197 views1 answer
Mysql time ago difference
SQL
0 vote182 views1 answer
Utiliser sql ligne de commande
SQL
0 vote206 views1 answer
Mysql utc timestamp
SQL
2 votes180 views1 answer
Oracle number to percentage
SQL
0 vote174 views1 answer
Check if table exists oracle
SQL
0 vote185 views1 answer
Mysql create pool
SQL