Get row count for most occurred field from content provider
When querying a content provider how to get the data that occures most number of times in a column. For example, Using the CallLog.Calls content provider if I want to get the phone number that occures in the log the maximum number of times? I guess in SQL the way would be to do something like COUNT(NUMBER)) GROUP BY开发者_StackOverflow社区 NUMBER
But, I suppose the query to content provider doesn't support GROUP BY (right?). What's the best way to achieve this? I want to get both the number of times the most used (most number of occurrences in the table) and also the number itself. Is it possible?
精彩评论