Sql, Spl, Database.
orders3=A1.groups(area;top(-10,amount))Top 10 orders of each area SPL regards TopN as the aggregation operation of returning a set, avoiding full sorting; The syntax is similar in case of whole set or grouped subset, and there is no need to take the roundabout approach. In most cases, writing