group by clause

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a group by clause but I have more than 10 field names.
Can this be done with 30+ field names?
 
Try SELECT DISTINCT * from YourTable;

I'm sorry to say that if you are grouping by 30 fields, there's a very, very
good chance that your tables are not normalized properly.
 
Yes, you can have more than 30 fields in the group by clause of a query.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Single WHERE and ORDER clause in UNION? 4
Can a group by clause be used with a user input? Please help me. 3
How do you remove a Group By from a query? 2
Grouping Expression 2
Referring to fields in a subquery 1
Optimization of Between Clause Queries 3
Subquery group by 4
Joining tables 1

Back
Top