Home » SQL & PL/SQL » SQL & PL/SQL » remove triplicate "Items count (9.0.4.0)
remove triplicate "Items count [message #320957] Sat, 17 May 2008 00:29 Go to next message
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,
Re: remove triplicate "Items count [message #320958 is a reply to message #320957] Sat, 17 May 2008 00:48 Go to previous message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
What does mean "items Count Variance for giving locations"?

Regards
Michel
Previous Topic: How to execute a procedure out side of the package which is not defind in the package spec.
Next Topic: Need Answer
Goto Forum:
  


Current Time: Tue Feb 11 10:15:22 CST 2025