ERROR: column must appear in the GROUP BY clause or be used in an aggregate function in PostgreSQL

Dung Do Tien Oct 29 2021 134

I'm a newbie in PostgreSQL. I have two tables are member and racinggameticket. I want to get all members was played the game. The relation of two tables is one - many.

Because one member can play the game many times. So I use group by command to help distinct records. See command below:

select rc.memberid, m.displayname from racinggameticket rc
inner join member m on m.id = rc.memberid
group by rc.memberid

But when running this command I got an error: column "m.displayname" must appear in the GROUP BY clause or be used in an aggregate function.

ERROR:  column "m.displayname" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: select rc.memberid, m.displayname from racinggameticket rc i...
                            ^
(execution time: 62 ms; total time: 422 ms)

Anyone can explain to me why this error is thrown and how to solve it?

Have 1 answer(s) found.
  • S

    Saurabh Shukla Oct 29 2021

    With GROUP BY command, any column appearing in SELECT command must appear in GOUP BY command.

    So you can fix your issue with the query below:

    select rc.memberid, m.displayname from racinggameticket rc
inner join membership m on m.id = rc.memberid
group by rc.memberid , m.displayname

    I hope this answer is helpful for you.

Related Q&A May You Like

  1. MySql throw no database selected, select the default DB to be used by double-clicking its name
  2. How to generate whole sql database script in MySql Workbench
  3. Error querySrv ENODATA _mongodb._tcp.456d in MongoDB Compass
  4. What is best way to convert datetime to date in Sql Server?
  5. How to compare date without time with now() in PostgreSQL?
  6. MySQL Error Code: 1175. safe update mode update a table without a WHERE
  7. ERROR 1819 (HY000): Your password does not satisfy the current policy requirements in MySQL
  8. Calculating distance between two positions(lat, long) in SQL Server
  9. MySQL Error: 'Access denied for user 'root'@'localhost'
  10. Error: /opt/lampp/bin/mysql.server: 264: kill: No such process
  11. How to get the total of current connection in PostgreSQL?
  12. How to backup and restore MSSQL Server database in Ubuntu
  13. ERROR: OFFSET must not be negative in PostgreSQL
  14. How to update top N records for a table in PostgreSQL?
  15. PostgreSQL Error: Terminating connection due to administrator command
Leave An Answer
* NOTE: You need Login before leave an answer

* Type maximum 2000 characters.

* All comments have to wait approved before display.

* Please polite comment and respect questions and answers of others.

Most Quizs Popular

Start Test

Javascript - Functions
Start Test

Asp.Net Core - Exam test 01
Start Test

Asp.Net Core - Exam test 02
Start Test

C# - Level Beginner

Popular Tips

This site uses cookies so that we can remember you and understand how you interact with our website. This allows us to improve and customize your browsing experience. See our Cookies Policy.
X Close