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
Sql pivot without aggregate
SQL
24 votes163 views2 answers
Alter table delete column
SQL
0 vote175 views1 answer
Get a list of tables and the primary key
SQL
2 votes170 views1 answer
Date conversion in mysql column
SQL
0 vote174 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
1 vote272 views1 answer
Aqua Data studio postgresql ssl
SQL
-1 vote166 views3 answers
SQL to LINQ converter
SQL
1 vote196 views1 answer
Difference between where and having clause
SQL
0 vote190 views1 answer
Postgres - Login and connect as default user
SQL
0 vote209 views1 answer
Find duplicate users by email address in mysql
SQL