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

1 vote156 views1 answer
Mariadb get column names from table
SQL
-1 vote151 views1 answer
How to open blade file from blade in laravel
SQL
19 votes160 views6 answers
Sql server drop table if exists
SQL
0 vote158 views2 answers
Postgres another version
SQL
1 vote163 views1 answer
Set statiscis on in ssms
SQL
2 votes150 views1 answer
Postgresql change value in column
SQL
2 votes174 views1 answer
Install postgresql centos 5
SQL
4 votes257 views6 answers
Laravel jwt
SQL
0 vote156 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
20 votes171 views5 answers
Reset auto increment mysql
SQL