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 vote198 views1 answer
Window functions in sql
SQL
0 vote215 views1 answer
Alter check command
SQL
0 vote214 views1 answer
Select into table variable
SQL
2 votes234 views2 answers
Mysql does sentence contain word
SQL
0 vote213 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
9 votes191 views3 answers
Sequence postgresql
SQL
1 vote232 views1 answer
Oracle see column type
SQL
6 votes194 views2 answers
WHERE value IS sql
SQL
15 votes200 views3 answers
Create table with primary key auto increment in sql
SQL
2 votes243 views1 answer
Tcl in sql
SQL