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 vote128 views1 answer
How to group by month using sql server
SQL
34 votes154 views6 answers
Alter table add foreign key mysql
SQL
13 votes113 views2 answers
Mysql order by multiple columns
SQL
0 vote117 views1 answer
Connexion mysql
SQL
-1 vote77 views2 answers
Sql query examples
SQL
0 vote152 views1 answer
How to make sure two tables have same exact data in sql
SQL
6 votes147 views3 answers
Rename column ORACLE
SQL
2 votes114 views1 answer
Sql alchemy or
SQL
4 votes108 views1 answer
Search column by name mysql
SQL
1 vote116 views1 answer
Psql autocomplete for mac brew install
SQL