Select top from sum

1

I have these sum data in my DB (counted dns requests to specify sites):

SELECT sum("destdnsReq") FROM "mikrotik" GROUP BY "dest"

name: mikrotik
tags: dest=www.fb.com
time sum
---- ---
0    2

name: mikrotik
tags: dest=www.google.com
time sum
---- ---
0    10

name: mikrotik
tags: dest=www.instagram.com
time sum
---- ---
0    5

Could you please somebody help me how to display only TOP 2 and order by sum

name: mikrotik
    tags: dest=www.google.com
    time sum
    ---- ---
    0    10

    name: mikrotik
    tags: dest=www.instagram.com
    time sum
    ---- ---
    0    5

Many thanks,

2

found it :slight_smile:

SELECT TOP(sum,dest,2) FROM(SELECT sum(req) 
      FROM mikrotik 
      WHERE time > now() - 4w 
      GROUP BY dest)
1 Like
3

This topic was automatically closed 60 minutes after the last reply. New replies are no longer allowed.