Query to extract top 20 contributors by transaction wise??

Question

In a Bank with millions of data, how to get top 20 persons who had more transactions for any particular month???

Answer 1

SELECT * FROM accounts ORDER BY totalTransaction DESC LIMIT 20