To: SSCertifiable

On your example

The wanted output should be 1,2,3,

thus for every date that there is a record for a specific id.

TO: MM

Actually my way was 2 times faster than yours

(my execution was 8sec and yours 16s).

How can this be??

I was sure that yours would be faster!!!!!

To:mister.magoo

Thanks very much ....

This is a very clever way and it works fine and faster than my query which was like

ACCOUNT_NO IN (

select distinct ACCOUNT_NO from t1.ALL_ACCOUNTS where STATUS_DORMANT...

To:SSC Veteran

I don't already know the id's.

So ....