group by clause

[Neshon30]

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?

 

[Jerry Whittle]

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.

 

[John Spencer]

Yes, you can have more than 30 fields in the group by clause of a query.