Within MySQL it is possible to get the Top N results while summing a
particular column in the database. For example:
SELECT ip_address, SUM(ip_count) AS count FROM table GROUP BY ip_address
ORDER BY count DESC LIMIT 5
This will return the top 5 ip_address based on the sum of ip_count.
Is there
Hi,
have a look at http://wiki.apache.org/solr/TermsComponent.
Regards,
Carlos.
2013/5/8 ld luzange...@gmail.com
Within MySQL it is possible to get the Top N results while summing a
particular column in the database. For example:
SELECT ip_address, SUM(ip_count) AS count FROM table GROUP
Unfortunately, terms do not help solve my issue.
To elaborate - say i have 5 entries:
uuid - ipaddress - ipcount
1 1.1.1.1 80
2 2.2.2.2 1
3 3.3.3.3 20
4 3.3.3.3 20
When i run a facet query on the ipaddress, i get the following results: