Re: Skill testing SQL question

From: Xuequn Xu <xux_at_informa.bio.caltech.edu>
Date: 5 Nov 1999 05:40:51 GMT
Message-ID: <7vtql3$ih7@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 Thu Nov 04 1999 - 23:40:51 CST