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 votes206 views1 answer
How to delete all duplicate items in mysql
SQL
18 votes168 views4 answers
Uninstall mysql ubuntu 18.04
SQL
0 vote182 views1 answer
Drop column from table if exist on live server mysql
SQL
15 votes174 views3 answers
Mysql update add to existing value
SQL
0 vote185 views1 answer
Oracle table privileges
SQL
1 vote179 views2 answers
Backup table mssql
SQL
0 vote175 views1 answer
How to fetch unique records from two tables
SQL
0 vote176 views1 answer
See Foreign Key
SQL
4 votes265 views1 answer
Select first and last row sql
SQL
0 vote180 views1 answer
Mysql check if lowercase
SQL