SQL Gateway / how to do it / List of values, determine MIN, MAX

, , , ,
2

Hi Chris,

Is this what you are looking for?

select min(a.year), max(a.year) from (select xyz, col as year from

where col in ()) a

I set up a simple test and it returned the min and max values out of my in list.

Thanks,
Bill Luton
R&D Director
CONNX Engineering
Software AG