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 vote168 views1 answer
Print hello world in plsql
SQL
0 vote135 views1 answer
Get initial in sql
SQL
0 vote130 views1 answer
Mysql 5.7 in centos 7
SQL
2 votes134 views1 answer
Date conversion in mysql column
SQL
0 vote139 views1 answer
Mssql dockere
SQL
5 votes141 views4 answers
Change auto increment mysql
SQL
0 vote116 views1 answer
Phpmyadmin mysql conflict
SQL
3 votes163 views1 answer
Mysql cli connect with password
SQL
1 vote139 views3 answers
How to truncate table with foreign key constraint
SQL
1 vote133 views1 answer
Sql current timestamp
SQL