Specialised Counts

From: Mark Starmer <markstarmer_at_hotmail.com>
Date: 4 Apr 2003 02:02:19 -0800
Message-ID: <8e45ea32.0304040202.b278dda@posting.google.com>

Is there a way (perhaps using nested SQL) to count the number of occurances of each distinct record ie

Input

---

John
John
John
Jim

Output

---

John - 3
Jim -1

Thanks a lot

M Starmer Received on Fri Apr 04 2003 - 04:02:19 CST