wood burning stoves*
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 Murach's Java Servlets and JSP this week in the Servlets 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: 78

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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Oracle - Retriving only latest data from a table if there is a Duplicate.
 
Similar Threads
CommunicationException in war file deployment
Query problem with MySQL 5
Problem with trying to Insert values into User
Get SUM of product quantity for product 'A' of Company 'XYZ' from database monthwise for whole year.
Get Sum of column and the retrive the data month wise.