G Guest Jan 31, 2006 #1 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?
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?
G Guest Jan 31, 2006 #2 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.
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.
J John Spencer Feb 1, 2006 #3 Yes, you can have more than 30 fields in the group by clause of a query.