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

2 votes266 views1 answer
Match in sql server
SQL
0 vote308 views1 answer
Select a row include list of array with join table SQL
SQL
0 vote244 views1 answer
Jooq finding lastest value in table
SQL
5 votes290 views1 answer
Minecraft java port number
SQL
0 vote285 views1 answer
Select amount weeks between two dates mysql
SQL
0 vote275 views3 answers
Sql select statements
SQL
0 vote303 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
0 vote330 views1 answer
Psql check if sql script is valid
SQL
0 vote272 views1 answer
Mysql select last 15 minutes
SQL
1 vote320 views1 answer
Oracle see column type
SQL