I dont think, there would be any query for that. there are two ways to do it.
You can try it out this way. select distinct would yield a set S which has distinct records. Copy all the distinct rows to a new table and delete the old table. then rename the new table. Arvind ----- Original Message ----- From: "aruri Badraiah" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 10, 2002 6:31 PM Subject: [LIH] help on sql deletion of records > > dear all members, > > if you are master in oracle > could you any body tell how to delete duplicate > records based on one numeric column that contains > some data(numeric). > > one record should be existed of duplicate column and > remaining should be deleted in one sroke. > > example: account_no ,count(*) > > 100 10 ( one should be existed) > 110 3 ( one should be existed) > 150 50 ( one shluld be existed) > > > > > thanks > with kind regards, > ab.hyd. > > > ________________________________________________________________________ > For live cricket scores download Yahoo! Score Tracker > at: http://in.sports.yahoo.com/cricket/tracker.html > > _______________________________________________ > linux-india-help mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/linux-india-help _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help
