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

8 votes188 views2 answers
Alter column name in mssql
SQL
4 votes264 views1 answer
How to drop a database in sql server when it is in use
SQL
8 votes241 views3 answers
SQL column name
SQL
0 vote238 views1 answer
Sql server change schema of a table
SQL
1 vote215 views1 answer
Scaffold mysql database
SQL
18 votes216 views3 answers
Mysql current date
SQL
2 votes233 views1 answer
Mysql trigger after update
SQL
0 vote221 views1 answer
Postgresql add not null and not empty constraint
SQL
1 vote215 views1 answer
Import database from a file using mysql commandline
SQL
1 vote236 views1 answer
Select tables with name like mysql
SQL