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 vote113 views1 answer
Postgresql can you have null foreign key
SQL
1 vote104 views1 answer
Sql delete row with auto increment
SQL
5 votes112 views1 answer
Mysql count lines
SQL
1 vote114 views1 answer
Default
SQL
2 votes123 views2 answers
Mysql search for column name in all tables
SQL
0 vote120 views2 answers
MySQL PARTITION BY month automatically
SQL
0 vote115 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
1 vote111 views1 answer
Mysql get max value and id
SQL
1 vote115 views1 answer
Drop column if exists sql server
SQL
0 vote111 views1 answer
How to start my sql server on mac
SQL