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

3 votes231 views1 answer
Export postgres database linux
SQL
0 vote255 views1 answer
Updating database in sql
SQL
3 votes233 views3 answers
How to add month in update sql
SQL
6 votes252 views1 answer
Oracle trigger after logon on database
SQL
0 vote263 views1 answer
Suhaib
SQL
0 vote243 views1 answer
Oracle array
SQL
0 vote276 views1 answer
Hibernate dialect property xml for mysql 8
SQL
-1 vote212 views2 answers
On delete set default sql server
SQL
0 vote208 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
36 votes300 views6 answers
Change column data type sql
SQL