does presto sql lack top x functionality in select statements?
if so, there workaround in meantime?
if want limit number of rows in result set, can use limit, or without order by:
select department, salary employees order salary desc limit 10 if want top values per group, can use standard sql row_number() window function. example, top 3 employees per department salary:
select department, salary ( select department, salary row_number() on ( partition department order salary desc) rn employees ) rn <= 3 