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 vote340 views1 answer
Python mysql executemany
SQL
1 vote350 views1 answer
Multiple count in sql
SQL
0 vote292 views1 answer
Oracle sql developer script output limit
SQL
0 vote378 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote356 views1 answer
Get null value in sql
SQL
1 vote346 views2 answers
Change table name phpmyadmin
SQL
14 votes371 views3 answers
How to add default constraint in mysql
SQL
0 vote395 views1 answer
Copy from one table to another postgres using matching column
SQL
0 vote373 views1 answer
Oracle swap partition
SQL
0 vote350 views1 answer
Inner join distinct
SQL