Why the “Group BY” by month didn’t work? [closed]

by

The group by clause, unlike the order by clause, doesn’t take column ordinals. In this clause, 1 and 2 are just integer literals, and since every row of your query has the same value for these two literals, they are all grouped in to a single result row.

Instead, you should use the actual columns from your query:

GROUP BY sql_activity_days.styleship_start_month, memberCountSql."122_days"

More Related Contents:

  1. PostgreSQL: Show tables in PostgreSQL
  2. PostgreSQL “DESCRIBE TABLE”
  3. PostgreSQL function for last inserted ID
  4. What’s the fastest way to do a bulk insert into Postgres?
  5. Adding ‘serial’ to existing column in Postgres
  6. Making sense of Postgres row sizes
  7. How to persist data in a dockerized postgres database using volumes
  8. Time zone names with identical properties yield different result when applied to timestamp
  9. Permission denied for relation
  10. CONSTRAINT to check values from a remotely related table (via join etc.)
  11. How do I get a column with consecutive, increasing numbers, without having any numbers missing?
  12. Execute a dynamic crosstab query
  13. Copy a table from one database to another in Postgres
  14. User defined variables in PostgreSQL
  15. PostgreSQL query very slow with limit 1
  16. psql: FATAL: database “” does not exist
  17. Postgres FOR LOOP
  18. Storing Images in PostgreSQL
  19. Strange behaviour in Postgresql
  20. Postgres: Distinct but only for one column
  21. In PostgreSQL, how to insert data with COPY command?
  22. Cursor based records in PostgreSQL
  23. Maximum characters in labels (table names, columns etc)
  24. Configuration parameter work_mem in PostgreSQL on Linux
  25. How to work with PGpoint for Geolocation using PostgreSQL?
  26. PostgreSQL INSERT ON CONFLICT UPDATE (upsert) use all excluded values
  27. Hashing a String to a Numeric Value in PostgreSQL
  28. Spring Docker container cannot access Postgres Docker container
  29. Format specifier for integer variables in format() for EXECUTE?
  30. PostgreSQL composite primary key

Leave a Comment