Facebook app count top users

I'm using facebook requests in my app. Lets say for example i have a table like this in my db:

fb_user_id request_id outstanding
id1        rid1       1
id1        rid2       0
id1        rid3       0
id2        rid4       1
id2        rid5       0
id2        rid6       0
id3        rid7       0

outstanding becomes 0 when a user accepts the request. The logic is when the field outstanding is 0 the user that made that request gets 10 points in my app.

Which is the syntax for a mysql query to find out top 100 users with higher points? Ι suppose using order and group by statements..

Answers


SELECT TOP 100
   fb_user_id
   SUM(outstanding) As OutstandingTotal
FROM YourTable
GROUP BY
   fb_user_id
ORDER BY DESC
   SUM(outstanding)

Need Your Help

SignalR push notifications to all browser instances of single authenticated user

javascript notifications signalr

I'm working on an application that needs to notify the user when they receive a new notification. The application will be hosted on Azure and will be .NET MVC 3 (probably not important, but FYI). ...

jQuery Slide to left right on a spitted Page

jquery css

I want to split a HTML Page by 50%. If the left side is clicked than it should slide up to 90%. The same is for the right side.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.