> any acts as > min

select *

from

(

select 'a' chr

union select 'b'

union select 'c'

union select 'd'

union select 'e'

) main

where main.chr > any

 (

 select 'a' chr

union select 'b'

union select 'c'

 )