Re: urgent

From: Rocky Welch <rockyw_99_at_yahoo.com>
Date: Wed, 18 Oct 2000 12:54:41 -0700 (PDT)
Message-Id: <10653.119706@fatcity.com>

Try:

Select rowid, <column 1>, <column 2>, ect... from <table_name>
where <blah, blah, blah>;

Delete from <table_name>
where rowid = <rowid of the row you want to delete>;

HTH,

• Swapna_P <Swapna_P_at_satyam.com> wrote:
  > how to delete the duplicate records from a table............
  > except for one field all the rest of the fields are the same,so want to
  > eliminate one record
  >
  > TIA
  > swapna
  >
  

  ---

Rocky Welch
Senior Consultant - Internet Services Group Arthur Andersen

---

Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE. Received on Wed Oct 18 2000 - 14:54:41 CDT