Received: from ece.rice.edu (ece.rice.edu [128.42.4.34]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f63Em7a04032 for ; Tue, 3 Jul 2001 10:48:07 -0400 (EDT) (envelope-from reedstrm@rice.edu) Received: from wallace.ece.rice.edu (wallace.ece.rice.edu [128.42.12.154]) by ece.rice.edu (Postfix) with ESMTP id 1352D68A14; Tue, 3 Jul 2001 09:48:02 -0500 (CDT) Received: from reedstrm by wallace.ece.rice.edu with local (Exim 3.22 #1 (Debian)) id 15HRSH-0008Do-00; Tue, 03 Jul 2001 09:47:09 -0500 Date: Tue, 3 Jul 2001 09:47:09 -0500 From: "Ross J. Reedstrom" To: ibrahim cobanoglu , pgsql-sql@postgresql.org Subject: Re: pls Help us... (sql question) Message-ID: <20010703094709.A31594@rice.edu> Mail-Followup-To: "Ross J. Reedstrom" , ibrahim cobanoglu , pgsql-sql@postgresql.org References: <20010703102342.89388.qmail@web14406.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20010703102342.89388.qmail@web14406.mail.yahoo.com> User-Agent: Mutt/1.3.18i X-Archive-Number: 200107/20 X-Sequence-Number: 3801 Best to ask your questions on the list, so others may find them, with (hopefully) helpful answers in the archives in the future. so, you've got a table with indistinguishable rows. I'm afraid you've got to use an non ANSI extension. Every DB I've ever used has something equivelant. In PostgreSQL, it's the 'oid', so in your case, you'd do: SELECT oid,Name from tablename; and see something like: oid Name ------- ------- 102453 ibrahim first row 102455 ibrahim second row 103756 ibrahim third row Then, you can delete, comparing on the oid: DELETE FROM tablename WHERE oid=102455; Ross On Tue, Jul 03, 2001 at 03:23:42AM -0700, ibrahim cobanoglu wrote: > Hi. my name is ibrahim > > i have one problem with multiple rows.. > > i have a table named record and this table consist one > field (name) > > in this field there are 3 values such as > Name > ------- > ibrahim first row > ibrahim second row > ibrahim third row > > i want to delete only the second row. ( with Ansi > SQL (no cursor, trigger, rowid, rownum,....etc.) use > select, count, .... (whats required!) ) > > but i dont know How to delete.. > > its really improtant for me. > > i will glad.... > > > > > > __________________________________________________ > Do You Yahoo!? > Get personalized email addresses from Yahoo! Mail > http://personal.mail.yahoo.com/