Re: A simple sql*plus question

This should do it:

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

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)
>
> TIA
>
> Brian
> bcamero5_at_metz.une.edu.au
Received on Fri Feb 07 1997 - 00:00:00 CST