Subject Re: [firebird-support] How do I count the number of duplicate rows in a table?
Author Tim Ward
Post date 2014-10-28T12:20:37Z
SELECT CASE_NUMBER, COUNT(*) FROM ACCT_CASE_COURT GROUP BY CASE_NUMBER

That what you want? (The sorting comes for free.)

On 28/10/2014 12:13, 'Softtech Support' stwizard@... [firebird-support] wrote:
 



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. 




-- 
Tim Ward