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 vote175 views1 answer
Primary key reset in SQL database
SQL
1 vote217 views2 answers
Postgres select from last 3 months
SQL
2 votes186 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
-1 vote139 views1 answer
How to create script to connect to oracle database and run query
SQL
1 vote172 views1 answer
Autocommit mysql
SQL
12 votes179 views4 answers
Mysql ifnull
SQL
0 vote196 views1 answer
How to alter length character varying postgres
SQL
4 votes181 views3 answers
Oracle sql first day of quarter
SQL
0 vote175 views1 answer
SQL Error 1040 : Too many connections
SQL
0 vote175 views1 answer
Dns slave zone convert
SQL