How do I get min, median and max from my query in postgresql?

by

To calculate the median in PostgreSQL, simply take the 50% percentile (no need to add extra functions or anything):

SELECT PERCENTILE_CONT(0.5) WITHIN GROUP(ORDER BY x) FROM t;

More Related Contents:

  1. What to do with null values when modeling and normalizing?
  2. Postgres: INSERT if does not exist already
  3. Truncating all tables in a Postgres database
  4. How can I drop all the tables in a PostgreSQL database?
  5. How to change PostgreSQL user password?
  6. How to get the count of current month Sunday’s in psql?
  7. Restore a postgres backup file using the command line?
  8. Running PostgreSQL in memory only
  9. How to close idle connections in PostgreSQL automatically?
  10. Refresh a materialized view automatically using a rule or notify
  11. postgresql – replace all instances of a string within text field
  12. Is it possible to have autoincrement number without it being an ID?
  13. PostgreSQL: Modify OWNER on all tables simultaneously in PostgreSQL
  14. How do I login and authenticate to Postgresql after a fresh install?
  15. PostgreSQL error ‘Could not connect to server: No such file or directory’
  16. Insert if not exists, else return id in postgresql
  17. function returns multiple columns as a single column instead of multiple columns
  18. Sequences not affected by transactions?
  19. Postgres: check if array field contains value?
  20. Dynamic pivot query using PostgreSQL 9.3
  21. PostgreSQL ERROR: canceling statement due to conflict with recovery
  22. Change type of varchar field to integer: “cannot be cast automatically to type integer”
  23. eliminate duplicate array values in postgres
  24. Find Parent Recursively using Query
  25. Is there a way to disable updates/deletes but still allow triggers to perform them?
  26. Error: Column does not exist in postgresql for update [duplicate]
  27. How to see the CREATE VIEW code for a view in PostgreSQL?
  28. How can I ensure that a materialized view is always up to date?
  29. PostgreSQL: Query has no destination for result data
  30. Error when pushing data to Heroku: time zone displacement out of range

Leave a Comment