Home » SQL & PL/SQL » SQL & PL/SQL » remove triplicate "Items count (
remove triplicate "Items count [message #320957] Sat, 17 May 2008 00:29 Go to next message
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: 65154
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What does mean "items Count Variance for giving locations"?

Previous Topic: How to execute a procedure out side of the package which is not defind in the package spec.
Next Topic: Question in Pl/Sql Joins
Goto Forum:

Current Time: Wed Aug 23 10:35:26 CDT 2017

Total time taken to generate the page: 0.06280 seconds