You can only select 1 distinct field.
Pick 1 field that you want to be distinct and
SELECT DISTINCT(that_field), other_field, other_field2, etc .... FROM table
Be careful which field you select distinctly.
Todd Ashworth
----- Original Message -----
From: "aslam bajaria" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 02, 2000 10:30 AM
Subject: RE: Help! (2)
| select distinct(*) gives an error.
| Also
| select distinct(column1, column2,...,LastColumn) gives
| an error.
|
| Can someone tell me how to avoid this error.
|
| Appreciate.
| A.B.
|
|
|
| --- Johan Coens <[EMAIL PROTECTED]> wrote:
| > Maybe:
| >
| > Step 1: SELECT DISTINCT ... (all colums), name it
| > qryAllRecords
| > Step 2: DELETE FROM <yourtable>, now you're table is
| > empty
| > Step 3: LOOP over qryAllRecords and insert them into
| > the database.
| >
| > Make sure you have a backup and use CFTRANSACTION!
| >
| > Best Regards,
| > Johan Coens
| >
| > -----Original Message-----
| > From: aslam bajaria [mailto:[EMAIL PROTECTED]]
| > Sent: woensdag 2 augustus 2000 6:30
| > To: [EMAIL PROTECTED]
| > Subject: Help!
| >
| >
| > Hello All,
| > There is a very seriuous problem I am facing. Please
| > help. The problem is as follows:
| >
| > Somehow I have created duplicate records in SQL
| > Server
| > 7.0 table.
| >
| > I have to remove the duplicate the records. It all
| > happened because there is no primary key when the
| > record was created.
| >
| > If it were a few records, I could have manually
| > deleted them. Now the records are in thousands. Can
| > someone suggest me a code that would check for
| > duplicate values in a table and delete them.
| >
| > Please help.
| >
| > A.B.
| >
| > __________________________________________________
| > Do You Yahoo!?
| > Kick off your party with Yahoo! Invites.
| > http://invites.yahoo.com/
| >
| --------------------------------------------------------------------------
--
| > --
| > Archives:
| >
| http://www.mail-archive.com/[email protected]/
| > To Unsubscribe visit
| >
| http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
| > or
| > send a message to [EMAIL PROTECTED]
| > with 'unsubscribe' in
| > the body.
| >
| >
| --------------------------------------------------------------------------
----
| > Archives:
| >
| http://www.mail-archive.com/[email protected]/
| > To Unsubscribe visit
| >
| http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
| > or send a message to
| > [EMAIL PROTECTED] with 'unsubscribe'
| > in the body.
|
|
| __________________________________________________
| Do You Yahoo!?
| Kick off your party with Yahoo! Invites.
| http://invites.yahoo.com/
| --------------------------------------------------------------------------
----
| Archives: http://www.mail-archive.com/[email protected]/
| To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
|
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
