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 vote361 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
6 votes358 views3 answers
Rename column ORACLE
SQL
3 votes353 views1 answer
Laravel database Using Named Bindings
SQL
0 vote346 views1 answer
SQL division of an integer by another integer get float CAST
SQL
0 vote331 views1 answer
Sql create text column limited values
SQL
2 votes316 views1 answer
Oracle sql drop table purge
SQL
0 vote357 views1 answer
Sql injection payload list github
SQL
0 vote321 views1 answer
Jooq replace
SQL
0 vote334 views1 answer
Mysql return column names when table is empty
SQL
23 votes341 views2 answers
Query to delete a database in mysql
SQL