Search Results

Usefulness of googlng decode and olap: 0

Thanks for trying.

I am aware of the use of case. I was already using it I just dumbed down the example to attempt to prevent simplistic answers like...

Thanks for the reply. Unfortunately, this is with Sybase, so I can't use those functions, nor cans I use PLSQL.

I have a table with the following structure:

trxNo expiryDate remoteTrxNo
445455 2011-06-26 0
445455 2011-02-26 0
445999 2011-07-30 0
445999 ...