Firebase Retrieve Highest 100 Score

This is a screen shot of my firebase: I am trying to retrieve the highest 100 score in firebase database I am using this code to add new node to firebase: Map

Solution 1:

Firebase queries are always in ascending order. So you'll need to get the last 100, instead of the first 100.

QueryqueryRef= myRef.orderByChild("score").limitToLast(100);

Then client-side you'll need to reverse the items.

Alternatively you can add a inverted property to your items invertedScore: -99. If you do that, you can order by that inverted score and won't have to reverse the array.

This scenario has been covered frequently before. I highly recommend you study some of these:

• data sorting in firebase
• Firebase Leaderboard, best Implmentation. SQL Joins and orderby (as recently as yesterday)
• Display posts in descending posted order
• Firebase Data Desc Sorting in Android
• Swift - How to create Sort query as Descending on Firebase?

Solution 2:

this is a way to fetch highest salary from firebas or get highest number from firebase

one   citiesRef.orderBy("name").limit(3);
two   citiesRef.orderBy("name", "desc").limit(3);
three citiesRef.where("population", ">", 100000).orderBy("population").limit(2);
four  citiesRef.where("population", ">", 100000).orderBy("population");

Share