Division of integers returns 0

by

You should cast before you divide, but also you were missing a subquery to get the total count from the table. Here’s the sample.

select 
  random_int,
  count(random_int) as Count,
  cast(count(random_int) as decimal(7,2)) / cast((select count(random_int) from test) as decimal(7,2)) as Percent
from test
group by random_int
order by random_int;

More Related Contents:

  1. Refactor a PL/pgSQL function to return the output of various SELECT queries
  2. PostgreSQL “Column does not exist” but it actually does
  3. Is SELECT or INSERT in a function prone to race conditions?
  4. Any downsides of using data type “text” for storing strings?
  5. Index for finding an element in a JSON array
  6. Query for array elements inside JSON type
  7. Calculating Cumulative Sum in PostgreSQL
  8. What is the expected behaviour for multiple set-returning functions in SELECT clause?
  9. Is it possible to make a recursive SQL query?
  10. Way to try multiple SELECTs till a result is available?
  11. PostgreSQL IF statement
  12. Split given string and prepare case statement
  13. Column ‘mary’ does not exist
  14. PostgreSQL: how to convert from Unix epoch to date?
  15. Postgres not using index when index scan is much better option
  16. SQL update fields of one table from fields of another one
  17. Postgres – Function to return the intersection of 2 ARRAYs?
  18. How to store array or multiple values in one column
  19. convert Postgres geometry format to WKT
  20. Which datatype should be used for currency?
  21. How to return two columns with function
  22. COPY with dynamic file name
  23. Table or column name cannot start with numeric?
  24. Count cumulative total in Postgresql
  25. PostgreSQL column ‘foo’ does not exist
  26. Prepared Statement on Postgresql in Rails
  27. PostgreSQL: Full Text Search – How to search partial words?
  28. Temporal database design, with a twist (live vs draft rows)
  29. How to bulk insert only new rows in PostreSQL
  30. PostgreSQL – dynamic value as table name [duplicate]

Leave a Comment