Subject Re: [firebird-support] How do I count the number of duplicate rows in a table?
Author Martijn Tonies (Upscene Productions)
Post date 2014-10-28T12:18:05Z
select count(case_number) as counted, case_number
from ACCT_CASE_COURT
group by case_number
 
?
 
With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
 
 
Sent: Tuesday, October 28, 2014 1:13 PM
Subject: [firebird-support] How do I count the number of duplicate rows in a table?
 

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.