Re: A simple sql*plus question

From: L120bj <l120bj_at_aol.com>
Date: 1997/02/23
Message-ID: <19970223124200.HAA16249@ladder02.news.aol.com>#1/1

Try
select a,b
from table
group by a,b
having count(*) > 1;

This will show all duplicated combinations of the pair a,b.

---

---

Subject: Re: A simple sql*plus question
From: boer009_at_ptt-telecom.nl (eddy)
Date: Mon, 10 Feb 1997 16:03:03 GMT
Message-ID: <5dngp0$se6_at_pwxl01.telecom.ptt.nl>

bcamero5_at_metz.une.edu.au (Brian Cameron) wrote:

-I need to select from a table where two columns are duplicated. I
know
-this may be really simple but if someone can help me out I'd
appreciate
-it.

-eg. select a,b from table where a and b are duplicated (occur in more
than
-one row)
Received on Sun Feb 23 1997 - 00:00:00 CST