Filter on the maximum value

[w860098]

I have an Oracle database where records are stored each week, each of these 'batches' being assigned a unique (sequential) Credit Run Number.
I wish to write an Impromptu report where relevant details are output BUT only for those records which have been created during the last update, i.e. I wish to filter on the maximum Credit Run Number.

I can achieve this in SQL*Plus using the code :-

Select CREDIT_RUN_NO, CLAIM_NO from WAR_FACT
where CREDIT_RUN_NO = (select MAX(CREDIT_RUN_NO) from WAR_FACT)
/

How can I achieve the same results when using Impromptu ?

 

[Draoued]

Ipen Query definition, in filter tab , select summary , instead of Details, then add CREDIT_RUN_NO = Maximum(CREDIT_RUN_NO)

 

[w860098]

Great - that worked just as I wanted it to.