On 2/19/07, Jim Crafton <[EMAIL PROTECTED]> wrote:
If I have a simple table without an index column, and have multiple rows with the same data, is it possible to *only* delete one row? In other words, is there anything like the LIMIT syntax that's found in the SELECT command for DELETEs?
you could select all distinct records in a temp table, drop the original table, and recreate the table CREATE TEMP TABLE tmp AS SELECT DISTINCT * -- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ Open Source Geospatial Foundation http://www.osgeo.org/education/ --------------------------------------------------------------------- collaborate, communicate, compete ===================================================================== ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
