|Subject||How do I count the number of duplicate rows in a table?|
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.
This email is free from viruses and malware because avast! Antivirus protection is active.