Skip to Content
0
Former Member
Jan 11, 2008 at 06:41 PM

Select Max record for the report

62 Views

Post Author: ROMZILBER

CA Forum: WebIntelligence Reporting

Hello,

Here is our problem we have history data on a table like

Example

Data:

11111 bbb 12/31/2004

11111 nnn 12/31/2005

11111 ddd 12/31/2007

On a report we only need to display the most current record (based on a date).

11111 ddd 12/31/2007

How can we do that, we have try to create subquery but it does not allowed to enter logic for the max date for the same id. So we are kind of stuck, I am more then sure this would be a very common conditions specially for data warehousing.

we are on Oracle 10g

Thank you for all your help.