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 vote356 views1 answer
Sql query contains multiple ids
SQL
3 votes333 views1 answer
Sql multi column index performance
SQL
2 votes352 views2 answers
How to create an empty table from an existing table
SQL
1 vote326 views1 answer
Show table columns
SQL
0 vote351 views1 answer
Mysql backup certain tables workbench
SQL
0 vote357 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
21 votes363 views3 answers
Sql server search column name in all tables
SQL
2 votes330 views2 answers
How to view created temporary tables in mysql
SQL
1 vote360 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
13 votes346 views2 answers
Get tables in database sql
SQL