Subject How do I count the number of duplicate rows in a table?
Author Softtech Support
Post date 2014-10-28T12:13:27Z

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.