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

2 votes320 views2 answers
Mysql limit
SQL
0 vote324 views2 answers
Disadvantages of stored procedures sql
SQL
2 votes316 views1 answer
Columns Present in a table
SQL
0 vote282 views1 answer
Oracle list all stored procedures
SQL
9 votes312 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
0 vote357 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
0 vote257 views1 answer
How to connect sql server using ip address in c#
SQL
2 votes331 views1 answer
Can you use a where clause for a child query
SQL
1 vote312 views1 answer
Import sql file mysql commadn line
SQL
0 vote302 views1 answer
Create table if not exist with exceptions
SQL