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 vote201 views1 answer
Low level operator in dbms
SQL
1 vote203 views1 answer
Spring postgresql reset auto increment to 0
SQL
1 vote284 views3 answers
Date_add mysql
SQL
12 votes198 views2 answers
Delete all nodes neo4j
SQL
0 vote293 views1 answer
How to find sql server name
SQL
7 votes201 views1 answer
Oracle set sequence value to max(id)
SQL
1 vote243 views1 answer
Select from describe sql
SQL
2 votes206 views2 answers
Mysql bidirectional composite primary key
SQL
59 votes7.7K views6 answers
Alter table sql
SQL
0 vote191 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL