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 vote247 views1 answer
Inner join distinct
SQL
1 vote185 views1 answer
Sometimes i cant edit sql developer
SQL
3 votes205 views1 answer
Start mysql server by terminal in linux
SQL
1 vote202 views1 answer
Alter database datafile maxsize 32g
SQL
0 vote175 views1 answer
Online sql testing tool
SQL
0 vote183 views1 answer
Sql injection mitigation
SQL
0 vote191 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
0 vote148 views1 answer
Connection error in mysql workbench
SQL
0 vote186 views1 answer
Sql DATE = GETDATE()
SQL
0 vote236 views1 answer
Postgresql remove new line from string
SQL