Skill testing SQL question

[Quoted] This is a good skill testing question
[Quoted] 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:

[Quoted] AA		BB
[Quoted] 1		x
[Quoted] 2		y
[Quoted] 3		z
1		x
2		y
3		z

You want to delete 3 rows, so that
[Quoted] 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
[Quoted] 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 Thu Nov 04 1999 - 22:01:45 CET