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 vote375 views2 answers
Create temporary table sql
SQL
0 vote353 views1 answer
Oracle drop default value
SQL
1 vote355 views1 answer
Pv mysql import
SQL
0 vote328 views1 answer
Mysql group rows with same value
SQL
0 vote358 views1 answer
How to use select union and loop
SQL
0 vote374 views1 answer
Sql output select
SQL
1 vote391 views1 answer
Mysql connect bash
SQL
0 vote380 views2 answers
Compound operator in sql
SQL
25 votes372 views1 answer
Mysql grant all privileges to a user
SQL
0 vote353 views1 answer
Database get 10 user aleatory
SQL