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 votes288 views2 answers
Sqlalchemy filter or
SQL
0 vote276 views1 answer
Psql attribute cannot login
SQL
0 vote276 views1 answer
Vowels in sql
SQL
0 vote280 views1 answer
Inserting data into different tables at once in oracle sql
SQL
0 vote280 views1 answer
Sql tablo sp
SQL
1 vote270 views2 answers
Mssql show database size
SQL
0 vote276 views1 answer
Connecting mySQL to STS
SQL
2 votes263 views3 answers
Replace null in sql
SQL
1 vote292 views1 answer
Spark sql convert string to date
SQL
2 votes318 views3 answers
How to replace null values in sql
SQL