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 vote197 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
0 vote203 views1 answer
Dump db only triggers mysql
SQL
3 votes195 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
0 vote225 views1 answer
Mysql conf.d exampel
SQL
2 votes193 views2 answers
Sqlalchemy filter or
SQL
5 votes246 views3 answers
Sql limit offset
SQL
6 votes197 views1 answer
What is where clause in sql
SQL
0 vote182 views1 answer
CREATE MULTIPLE FK
SQL
1 vote285 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
1 vote198 views1 answer
Altering the column name in MySQL to have a default value
SQL