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