Need SQL select help please...

[DougCMH]

Try this. This worked for me.

---

Code

[Guest.Visitor]

Try this, SELECT FLD1, FLD2, FLD3, FLD4, COUNT(*) AS COUNT FROM FILE1 GROUP BY FLD1, FLD2, FLD3, FLD4 ORDER BY FLD1, FLD2, FLD3, FLD4

[danbo@danbo.com]

Lack of enough experience is frustrating trying to figure this one out. I have a table with 4 values as such: REC1 12345 ABC 45678 90123 REC2 12345 ABC 45678 90123 REC3 12345 DEF 45678 90123 REC4 23456 ABC 12345 67890 REC5 23456 ABC 12345 67890 Basically, I need to group the records by the first two values, perhaps using distinct. Yet, I don't want a single record without also having a count of the records where the first two values match. Basically, the result would be something like: REC1 12345 ABC 45678 90123 2 REC2 12345 DEF 45678 90123 1 REC3 23456 ABC 12345 67890 2 I've tried a number of things to ATTEMPT to count them all up with a select statement (need to do some additional processing anyway), but to no avail. I just don't have the knowledge yet on how to not only do a count, but also distinct while giving me all the columns I still need for the additional processing. Any suggestions?

[danbo@danbo.com]

Thanks to both of you for the assist on this. Gonna have to write that one down for future reference. The quick response was greatly appreciated.