0

Query to extract top 20 contributors by transaction wise??

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

16th May 2017, 7:24 AM
Atheeth Bhat
Atheeth Bhat - avatar
1 ответ
+ 3
SELECT * FROM accounts ORDER BY totalTransaction DESC LIMIT 20
16th May 2017, 7:40 AM
Calviղ
Calviղ - avatar