Re: simple PL/SQL Question: deleting repeated rows

Think about a query that will identify which rows have duplicate values. Then use it as a subquery.

Daniel Morgan

Mario Christ wrote:

> Hi,
>
> I am just starting with PL/SQL. Maybe someone can help solving a very
> simple problem.
>
> suppose you have the following table (one row only):
>
> ROW1
> A
> B
> B
> C
> B
>
> how do I delete the repetitions? The table I want to get would be:
> ROW1
> A
> B
> C
> B
>
> thank you in advance,
> Mario Christ, Berlin
Received on Wed Mar 27 2002 - 11:18:25 CST