remove triplicate "Items count [message #320957] |
Sat, 17 May 2008 00:29  |
user71408
Messages: 585 Registered: November 2007 Location: NE
|
Senior Member |
|
|
Hi all,
A table contains millions of records. Now I want to remove triplicate "Items count
variances" for giving locations from the table.
The table contains "Itemno","location","create_date","status","Location_type".
The locations are 7001,7866,9876,9087.
these locations contains same no.of records.( Eg .. Total records in this all
locations is 80000.
each location contains 20000 reocrds.
So please let me know how to remove the triplicate items Count Variance for
giving locations.
Thank you,
|
|
|
|