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 vote288 views1 answer
TSQL function split string
SQL
0 vote288 views1 answer
Create function syntax sql server
SQL
6 votes298 views2 answers
Oracle
SQL
2 votes244 views1 answer
Oracle current date without time
SQL
0 vote263 views1 answer
Check sql query executed wp
SQL
1 vote285 views1 answer
Oracle rolling back transactions
SQL
0 vote297 views2 answers
How to use aggregate functions in sql
SQL
9 votes312 views6 answers
Oracle substring
SQL
0 vote288 views2 answers
How to relationship query two different tables in MySQL
SQL
1 vote267 views2 answers
Procedure pl/sql
SQL