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 vote286 views1 answer
Authentication modes in sql server
SQL
0 vote257 views1 answer
Mysql cdn link
SQL
0 vote231 views1 answer
Update row in sqlite python
SQL
1 vote269 views1 answer
Oracle schema size
SQL
3 votes304 views2 answers
Truncate table
SQL
0 vote290 views1 answer
Différence entre deux dates sql oracle
SQL
0 vote270 views1 answer
How to find columns with null values in sql
SQL
0 vote294 views1 answer
Amount of entries in a table psql
SQL
0 vote264 views1 answer
Update view sql
SQL
1 vote250 views1 answer
How to get alternate records from a table in sql
SQL