[MySql] Sort Contents based on two different value

A very important Sorting query that sort contents of a table according to two values. if values are equal based on first value then it sort contents according to second value. Here i have showed a query that sort contestants according to number of problem solved. If number of problem solved is equal then sort according to points.


Query : 

SELECT sname, SUM(status) As Solved, SUM(point) As Points FROM submission Where cid='1' GROUP BY sname ORDER BY Solved DESC , Points DESC

 

 

Download Coding Interview Book and Get More Tutorials for Coding and Interview Solution: Click Here

Download System Design Interview Book and Get More Tutorials and Interview Solution: Click Here

Do you need more Guidance or Help? Then Book 1:1 Quick Call with Me: Click Here

Share on Google Plus

About Ashadullah Shawon

I am Ashadullah Shawon. I am a Software Engineer. I studied Computer Science and Engineering (CSE) at RUET. I Like To Share Knowledge. Learn More: Click Here