[firebird-support] How do I count the number of duplicate rows in a table?

['Softtech Support' stwiz...@att.net [firebird-support]]

Greetings All,

Firebird 1.5.3

Should be elementary but, I'm drawing a blank on how to accomplish this.

I have a table (ACCT_CASE_COURT) that contains these fields (among others):

ACCT_CASE_COURT_ID    INTEGER    NOT NULL    PK
ACCT_ID    INTEGER    NOT NULL
CASE_ID    SMALLINT    NOT NULL
CASE_NUMBER    VARCHAR(20)    NOT NULL
...

How do I form a SQL Select statement that would contain CASE_NUMBER in the 
first column (sorted) and number of times that the case number is found in the 
table in the second column (CNT)?

Any help truely appreciated.

Thanks,
Mike







---
This email is free from viruses and malware because avast! Antivirus protection 
is active.
http://www.avast.com