converting int to real in sqlite

by

Just multiply one of the numbers by 1.0:

SELECT something*1.0/total FROM somewhere

That will give you floating point division instead of integer division.

More Related Contents:

  1. Selecting more than one value
  2. Is it possible to insert multiple rows at a time in an SQLite database?
  3. SQLite Reset Primary Key Field
  4. How do I dump the data of some SQLite3 tables?
  5. SQLite – How do you join tables from different databases?
  6. Declare variable in SQLite and use it
  7. Does SQLite3 not support foreign key constraints?
  8. Query to get records based on Radius in SQLite?
  9. How do I add a foreign key to an existing SQLite table?
  10. How to use SQL Order By statement to sort results case insensitive?
  11. Division of integers returns 0
  12. Double colon `::` notation in SQL
  13. SQL error “ORA-01722: invalid number”
  14. Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine
  15. Is there AUTO INCREMENT in SQLite?
  16. Discard millisecond part from timestamp
  17. Get month from DATETIME in sqlite
  18. GROUP_CONCAT in SQLite
  19. How do I cast a string to integer and have 0 in case of error in the cast with PostgreSQL?
  20. sqlite equivalent of row_number() over ( partition by …?
  21. Android multiple databases open
  22. How to convert PostgreSQL 9.4’s jsonb type to float
  23. sqlite select with condition on date
  24. How to compare sqlite TIMESTAMP values
  25. Convert String to Date in MS Access Query
  26. SQlite: select into?
  27. SQLite Order By Date1530019888000
  28. SQL error: misuse of aggregate
  29. How to use a calculated column by another calculated column
  30. Copy table structure to new table in sqlite3

Leave a Comment