Alternate of Min/Max
I have a query which uses Min function.
I want to use something alternate in order to avoid Min/Max or order by.
I have a query which selects a row based on the min value of one of its column.
how to avoid the use of min..
ex:
a query is like
Select a.name from all_names a
where a.active_date = (select min(active_date) from all_names ))