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 vote297 views1 answer
Sql search all columns of database oracle sql
SQL
4 votes344 views1 answer
Rename stored procedure in sql server
SQL
0 vote310 views1 answer
Postgresql interview questions
SQL
0 vote303 views1 answer
Min and max salary and name in sql
SQL
0 vote313 views2 answers
Raise notice in postgresql function
SQL
0 vote295 views1 answer
2020 new year
SQL
0 vote262 views1 answer
Calculate discount from original price sql
SQL
0 vote311 views5 answers
Sql table intermédiaire
SQL
1 vote324 views1 answer
Table information in sql server
SQL
0 vote293 views1 answer
Flask sqlalchemy decimal
SQL