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' [email protected]
[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
------------------------------------------------------------------------
<http://www.avast.com/>
This email is free from viruses and malware because avast! Antivirus
<http://www.avast.com/> protection is active.
--
Tim Ward
