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 vote152 views1 answer
Oracle stop
SQL
3 votes160 views2 answers
Oracle drop sequence
SQL
0 vote142 views1 answer
Exit psql
SQL
3 votes137 views2 answers
Mysql create timestamp column
SQL
-1 vote141 views1 answer
What is in operator
SQL
0 vote151 views1 answer
Query archive mode
SQL
2 votes149 views2 answers
Mysql on duplicate key update get value from values
SQL
2 votes123 views1 answer
How to delete columns in sql
SQL
0 vote262 views1 answer
Generate a random otp in sql server
SQL
0 vote148 views1 answer
Query to remove duplicate rows from a table
SQL