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

Reply via email to