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

2 votes312 views1 answer
Mysql time ago difference
SQL
0 vote309 views1 answer
Sql select column names starting with
SQL
15 votes324 views2 answers
Select Options
SQL
7 votes355 views4 answers
Index in mysql
SQL
0 vote320 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
0 vote323 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote330 views1 answer
How to select an index in oracle sql
SQL
0 vote317 views1 answer
Inser into example
SQL
0 vote318 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
0 vote328 views1 answer
Mysql count unique in group statement
SQL