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

19 votes182 views5 answers
Date between in mysql
SQL
0 vote158 views1 answer
Delete data from database sqlite android
SQL
0 vote169 views1 answer
Limit and offset in stored procedure mssql
SQL
0 vote142 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
2 votes183 views1 answer
Oracle convert run_duration to number
SQL
0 vote163 views4 answers
How to drop all tables in sql
SQL
0 vote165 views1 answer
Mysql remove tabs from string
SQL
1 vote164 views2 answers
Postgres copy table from one schema to another
SQL
0 vote171 views1 answer
Sql server user permissions and roles
SQL
0 vote176 views1 answer
Select * where id = 1,2,3
SQL