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 vote169 views1 answer
Add time to date sql
SQL
3 votes127 views2 answers
Postgres show table schema
SQL
0 vote123 views1 answer
Postgresql remove new line from string
SQL
12 votes110 views5 answers
Sql merge
SQL
0 vote129 views1 answer
Sql shell psql cannot enter password
SQL
0 vote123 views1 answer
Comparing with today and yesterday record in sql query
SQL
1 vote124 views2 answers
Update with inner join sql server
SQL
1 vote128 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
0 vote119 views2 answers
Raise notice in postgresql function
SQL
-1 vote158 views3 answers
Error: mysql shutdown unexpectedly.
SQL