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 vote186 views1 answer
Mysql select where field like in list
SQL
1 vote275 views1 answer
Oracle transaction rollback not working
SQL
1 vote229 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
2 votes182 views1 answer
Create table with primary key
SQL
2 votes206 views6 answers
Mysql change timezone
SQL
3 votes181 views3 answers
Concatenation in sql
SQL
1 vote189 views1 answer
Mysql view command
SQL
0 vote253 views1 answer
Get initials name in sql
SQL
0 vote227 views1 answer
Duplicate value unique constraint mysql error
SQL
0 vote187 views1 answer
Oracle job class
SQL