I have a table with three attributes: NAME, LOCATION, and AREA. I want to get the row with the largest area, for each name. In Oracle, I can do so with this query:
select
name,
location,
area
from (
select
name,
location,
area,
max(area) over (partition by name) as max_area
from mytable
)
where area = max_area
I could put this into a SQLExecutor, but I'd like to be able to do this even if my data source isn't Oracle.
Can I accomplish this using FME transformers instead?
