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

0 vote179 views1 answer
Mysql remove last character
SQL
0 vote163 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote169 views2 answers
Postgres having
SQL
0 vote150 views1 answer
Set a value by excuting stored procedure
SQL
0 vote157 views1 answer
If column value is null then in mysql
SQL
1 vote153 views1 answer
Postgresql transaction discard all
SQL
-1 vote155 views1 answer
Su: Authentication failure mysql
SQL
2 votes102 views1 answer
Mysql admin u root p password change password
SQL
0 vote159 views1 answer
Setval in postgres
SQL
1 vote150 views4 answers
Get week day from date in sql
SQL