How can I extract top 5 sums?

Question

=QUERY('BD3'!A:Q,
"SELECT L,D,I,SUM(M)
WHERE I='W34' AND M>0 AND L='Huacho' 
GROUP BY L,D,I",-1)

I need to just show the top 5 sums of column M.

If this works anything like MySQL or Presto then `ORDER BY` and then `LIMIT 5` — urdearboy, Aug 26 '21 at 15:54

score 1 · Accepted Answer · answered Aug 26 '21 at 15:59

1

=query('BD3'!A:Q, "SELECT L,D,I, SUM(M) WHERE I='W34' AND M>0 and L='Huacho' GROUP BY L,D,I ORDER BY SUM(M) DESC LIMIT 5",-1)

answered Aug 26 '21 at 15:59

GoranK

1 Answers1