Re: Skill testing SQL question
Date: 5 Nov 1999 05:40:51 GMT
Message-ID: <7vtql3$ih7_at_gap.cco.caltech.edu>
You can use rowid. This is a very easy, and classical one :-)
Xuequn Xu
argosy22_at_my-deja.com wrote:
: 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 - 06:40:51 CET