Error message when I use GROUP BY

  • Thread starter Thread starter TakeshiKitano
  • Start date Start date
T

TakeshiKitano

Guest
Hi all,

I have table with one id int and other columns of varchar(50) .... so I want to use

SELECT * FROM Clients GROUP BY cllient_number

But some error appears ...

Column 'Client.id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Continue reading...
 
Back
Top