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

6 votes231 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
11 votes236 views5 answers
Sql server reset identity
SQL
6 votes237 views3 answers
Oracle all dates between two dates
SQL
0 vote268 views1 answer
Postgres rename database
SQL
0 vote248 views2 answers
Start mysql server using docker
SQL
-1 vote216 views1 answer
Mysql extract days
SQL
1 vote236 views3 answers
Sql procedure
SQL
0 vote217 views1 answer
Codigo crear tablas sql server
SQL
0 vote201 views2 answers
Sql select inside select
SQL
0 vote261 views1 answer
Sql values that contains certain multiple ids
SQL