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

1 vote356 views1 answer
Data type and their numeric form
SQL
1 vote341 views1 answer
Mysql select month and year
SQL
10 votes345 views2 answers
Reset mysql root password mac
SQL
0 vote352 views1 answer
Sql list dates between two dates
SQL
0 vote378 views1 answer
Vbscript connect mssql
SQL
0 vote362 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote352 views1 answer
Make a socket server to detect changes in mysql
SQL
0 vote363 views1 answer
Sql on-premises
SQL
0 vote365 views1 answer
Sql put two columns into one
SQL
0 vote371 views1 answer
Pgsql is not permitted to log in
SQL