File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP 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: 3610
    
  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.