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 vote278 views1 answer
Postgresql select fast check no rows
SQL
1 vote264 views1 answer
Set mysql mode global query
SQL
0 vote315 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote262 views1 answer
Sql cross apply vs join
SQL
0 vote284 views1 answer
Like date sql server not working
SQL
2 votes237 views1 answer
Sql select in list
SQL
0 vote284 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote277 views1 answer
Phpmyadmin tabellentyp ändern
SQL
3 votes263 views1 answer
Search for column name in psql
SQL
3 votes294 views1 answer
Get current month last date in sql server
SQL