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 vote92 views1 answer
Mysql count all table rows
SQL
0 vote119 views2 answers
Create-toys-table-with-toy_name-column
SQL
0 vote103 views1 answer
Components/Fields of Internal Table
SQL
0 vote111 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
22 votes107 views3 answers
SQL CHEATSHEET
SQL
5 votes104 views1 answer
Sql integer to serial
SQL
0 vote115 views1 answer
Select into table variable
SQL
0 vote108 views1 answer
Linux upload database to mysql
SQL
0 vote72 views2 answers
Delete the last item in a table sql
SQL
0 vote105 views1 answer
Oracle right characters
SQL