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

2 votes147 views6 answers
Mysql change timezone
SQL
0 vote133 views1 answer
Kotlin sqlite delete row
SQL
17 votes142 views3 answers
Cast in sql server
SQL
0 vote158 views2 answers
Dbms transaction tutorialspoint
SQL
0 vote142 views1 answer
Oracle dynamic select into
SQL
0 vote136 views1 answer
How to count with except in psql
SQL
0 vote152 views1 answer
Reset keys in sql
SQL
0 vote140 views1 answer
C# check if mysql query modified rows
SQL
1 vote134 views2 answers
Sql server backup table
SQL
7 votes154 views1 answer
Sql pagination oracle
SQL