Re: Please help write a query **Urgent** tks

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Tue, 31 Jul 2001 10:45:47 +0200
Message-ID: <9k5rcc$p76$1@ctb-nnrp2.saix.net>

"OCP" <mr_ocp_at_yahoo.com> wrote

> We have a table the contains several duplicate records however each record
> is with an unique primary key, I need to write a query to see how many
> records are duplicate, there is a name field which has several duplicate
> names under separat unique id, so is there a way that I can find out how
> many such duplicate names exists in the table.

You are totally without slack. Calling yourself "Mr OCP" (as in Oracle Certified Professional I assume) and then asking a silly beginner question like this!?

Ever heard of the GROUP BY clause Mr OCP..?

--
Billy

Received on Tue Jul 31 2001 - 03:45:47 CDT