I wanted the following query to be executed,
String selectQuery = "SELECT max(score),name FROM " + TABLE_SCORE
+" group by name";
I get my output as random values. Actually I wanted the data from the maximum values to the least. Please let me know, how to write the query.
Actually I wanted the data from the maximum values to the least
You mean order by max to min value? Try this:
SELECT SUM(score), name
FROM MyTable
GROUP BY name
ORDER BY SUM(score) DESC;
So your query should be like this:
String selectQuery = "SELECT SUM(score), name FROM " + TABLE_SCORE
+" GROUP BY name ORDER BY SUM(score) DESC";
@username to reply particular user. :)
String selectQuery = "SELECT score, name FROM " + TABLE_SCORE
+" order by score, group by name";
This will give you the records according to the scores(Ascending order of score).
