Skill testing SQL question

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 Thu Nov 04 1999 - 15:01:45 CST