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 vote265 views2 answers
MySQL PARTITION BY month automatically
SQL
0 vote288 views1 answer
Mysql average from two table
SQL
1 vote254 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
0 vote256 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
0 vote254 views1 answer
Sqlalchemy sequence postgresql
SQL
1 vote265 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote264 views1 answer
Select row with latest date mysql
SQL
1 vote241 views1 answer
Sql select table header
SQL
0 vote251 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
0 vote254 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL