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 vote250 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
8 votes199 views1 answer
Oracle search code in packages
SQL
0 vote193 views1 answer
Set mysql socket file docker windows
SQL
4 votes183 views1 answer
Oracle table statistics last analyzed
SQL
6 votes196 views5 answers
Mysql get last insert id
SQL
1 vote196 views3 answers
Alter schema sql server
SQL
18 votes186 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
0 vote198 views1 answer
Oracle list datafiles
SQL
0 vote217 views1 answer
Spark sql grows beyond 64 kb
SQL
1 vote192 views1 answer
Add time to date sql
SQL