This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes Oracle - Retriving only latest data from a table if there is a Duplicate. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Reply locked New topic
Author

Oracle - Retriving only latest data from a table if there is a Duplicate.

Shahir Deo
Ranch Hand

Joined: Mar 19, 2013
Posts: 80

Hi Guys,

We are writing one select query to display the data in the table for Report purpose in GUI.

The Problem is In the Report we have duplicates (older data),

Ex:

Value -------------Start Date------------End Date-------------ID
1. XYZ(01) -------------21-01-13-------------21-01-14-------------01
2. XYZ(07) -------------11-01-13-------------11-01-14-------------07
3. XYZ(01) -------------21-01-12-------------21-01-13-------------01
4. XYZ(05) -------------05-01-11-------------21-06-11-------------05

After the Insertion of new record in table sr .1
it is displaying All the 1 , 2, 3, 4 .

But i need to eliminate or do not want to show the old ID :01 (sr.3) as the new ID:01 is inserted in Table.

Please Help.

Thanks


Knowledge enlivens the soul.
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3606
    
  60

Let's continue the discussion in your other thread.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Oracle - Retriving only latest data from a table if there is a Duplicate.
 
Similar Threads
Get SUM of product quantity for product 'A' of Company 'XYZ' from database monthwise for whole year.
CommunicationException in war file deployment
Query problem with MySQL 5
Problem with trying to Insert values into User
Get Sum of column and the retrive the data month wise.