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

5 votes149 views1 answer
Oracle list functions
SQL
1 vote154 views1 answer
How to delay stored procedure execution in sql server
SQL
0 vote183 views1 answer
Regex mongoose
SQL
0 vote128 views1 answer
Postgres week number
SQL
0 vote138 views1 answer
Drop CHECK constraint sql
SQL
0 vote140 views1 answer
Influxdb clone measurement
SQL
2 votes186 views1 answer
Db.relationship sqlalchemy flask
SQL
0 vote154 views1 answer
Update database collation in postgresql
SQL
-1 vote149 views1 answer
Capitole toulouse
SQL
0 vote142 views1 answer
Tsql table column constraint must be uppercase
SQL