Jump to content

SQL Group BY Error


houssam_ballout
 Share

Recommended Posts

How could I solve it ?
Well, that depends on what you actually want the query to do! :) What data do you want it to return? A count, a set of rows, or what? Perhaps if you could give an example of some data you'd like to see returned from your query, we can suggest the right fix.
Link to comment
Share on other sites

  • 2 weeks later...

I can suggest something already:Using such function as COUNT, will return a single value, and selecting various columns will result in a set of rows (much more complex than just a value). If you want both returned, eg. a value and a set of rows, you should separate them in two SELECT queries :)

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...