column is invalid in the select list because it is not contained in either an aggregate function

Nanu answered on October 10, 2022 Popularity 9/10 Helpfulness 1/10

Comment

SELECT A, COUNT(B) AS T1, B
FROM T2
GROUP BY A, B

Popularity 9/10 Helpfulness 1/10 Language whatever

Source: Grepper

Tags: aggregate either function list select whatever

Link to this answer
Share Copy Link

Contributed on Apr 26 2023

Nanu

0 Answers Avg Quality 2/10

Closely Related Answers

Comment

count how many b's and Group by a
SELECT a, COUNT(b)
FROM C
GROUP BY a

Derived from Explanation by Bill from Stack

Popularity 10/10 Helpfulness 1/10 Language whatever

Tags: aggregate aggr

Link to this answer
Share Copy Link

Contributed on Oct 10 2022

Ruan Hart

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.