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 vote147 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
0 vote115 views1 answer
Sqlalchemy existing database
SQL
36 votes164 views3 answers
Add column in mysq
SQL
0 vote175 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote135 views1 answer
First Step in installing SQL workbench
SQL
1 vote141 views1 answer
Postgres set column equal to another
SQL
1 vote173 views1 answer
Encrypt password postgresql
SQL
0 vote149 views1 answer
Oracle synonym procedure dblink
SQL
0 vote146 views1 answer
Sql column as header
SQL
0 vote174 views1 answer
MySQL get all previous date record
SQL