contex Posted January 24, 2010 Share Posted January 24, 2010 Hello, I'm trying to get some values from my database. I have table called deaths: id | date | victim | victimid | murderer | murdererid What I would like it do is to get the top 5, with the most kills, and deaths from the list. So for every death, there is a new insert in the table, so if murderer "Thekiller", has killed 14 diffrent players, and another murderer "TheNazit", has killed 9 diffrent players. This would put "Thekiller" on place no. 1, and "TheNazit" on place number 2. Any ideas? Quote Link to comment Share on other sites More sharing options...
fenway Posted January 25, 2010 Share Posted January 25, 2010 You mean a GROUP BY, COUNT(*) with an ORDER BY clause? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.