Re: Skill testing SQL question

TRY THIS CREATE TABLE NO_DUPE AS (SELECT DISTINCT * FROM DUPE_TABLE) DROP TABLE DUPE_TABLE
ALTER TABLE NO_DUPE RENAME TO DUPE_TABLE Incidentally, this is a question that I also ask at interviews, and ain't got an answer to date.

Regards,
VJ

<argosy22_at_my-deja.com> wrote in message news:7vss7n$c36$1_at_nnrp1.deja.com...
> Hello all,
>
> This is a good skill testing question
> that I was asked in an interview.
>
> You have a table, DUPE_TABLE,
> with two fields, AA, and BB.
> No primary key. Dupe data.
> Only 6 rows.
> 2 sets of the same exact 3 rows.
>
> DUPE_TABLE:
> AA BB
> 1 x
> 2 y
> 3 z
> 1 x
> 2 y
> 3 z
>
>
> You want to delete 3 rows, so that
> you have only one set of 3:
>
> AA BB
> 1 x
> 2 y
> 3 z
>
>
> To date, I haven't been able to
> figure out the answer.
> Does anyone have any ideas
> how to delete these dupe rows
> with SQL code?
>
> Happy puzzling,
>
> Argosy
>
>
>
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Nov 05 1999 - 03:58:20 CST