SQL -- question ...

From: peter nichola draper <nik127_at_unm.edu>
Date: 1995/04/04
Message-ID: <3lse0n$hdq_at_lacerta.unm.edu>#1/1

Newsgroups: comp.databases.oracle

Subject: SQL --- Question ???
Summary: 
Expires: 

Sender: nik127_at_unm.edu
Followup-To:
Distribution: comp.databases.oracle
Organization: University of New Mexico, Albuquerque Keywords:
Cc: nik127_at_unm.edu

Hello,
Hope someone out there can help me with I hope a quickie answer.
I'm looking for an sql script that deletes duplicate rows. Criteria: No unions allowed the table has Megs of data.

          Rows may have all the same fields in them.

for example

table duprows (time number, val1 number, val2 number)

with the values

      TIME VAL1 VAL2
---------- ---------- ----------

6353902.24          1          2
6353902.24          2          2
6353902.26          3          3
6353902.27          9          9
6353902.27          9          9

new table should be

6353902.24          1          2
6353902.26          3          3
6353902.27          9          9

if the time field is duplicated I only want one entry. doesn't matter which one ....

Thanks in advance

Lizz Draper   Received on Tue Apr 04 1995 - 00:00:00 CEST