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 votes182 views1 answer
Pdo mysql insert
SQL
0 vote181 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
14 votes178 views2 answers
Oracle add column with default value
SQL
1 vote180 views1 answer
Expression number 1 of select list is not in group by clause
SQL
7 votes189 views2 answers
N highest salary in sql
SQL
-1 vote278 views5 answers
Left join sql
SQL
0 vote200 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
5 votes171 views2 answers
Sql conn
SQL
1 vote170 views1 answer
Psql datetime grather than
SQL
0 vote177 views1 answer
Sql server select top 2 of each group
SQL