mysql添加为成绩表添加名次

时间:2023-03-10 02:38:44
mysql添加为成绩表添加名次

对于一种这样的表,为score添加名次

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAC8AAACbCAIAAAB9HlWYAAADqklEQVR4nO3czW7TQBAA4HkeekSWgl8hDxGph5X6FhzAlbjEr1BObU65YFQSTpxA5NTevDcECKVES3+S0joOh43j9axtqqjrcdQZzaVVIn3adZqZ3VFhZYSU8ttiRZVSSmANax5Pcx4+B//lufWeoYBO+Olpa6rStWZxe6czSZZSyo+/V3V5IsAL39a/Ztus1nwN90Acrl8XdcEIp5r54q/OCk3UBeierN9w2GtWM75Ixxfp+Et/D0RwkY6PBXj9I/1L+8dHzYJmuWyB5mZ+qzNZLqWUo2k6mqajz/1nIF5P09H0XRege5yOpuloGh94AF7/SL/msfMhmnR0LLIH+MXBK+FWc32z0Kmfmw+zJVVKKeHqeq5zrfmxpMoSzemvhCqllHB5daMzSRIp5en3hCqllPDn8lrnfZJIKd//vKfK9mlkmwLQd/qKLpRSrGENa7aJSACAiOg1cegD+EL4FRpUmTrW5KZyDQC0S7MBtUJj1snEGlS1E2tQnfykNHHom110waSUAlS1O9bUhVIKUNVOrEFVO7WmWLUTa1CdzBpDg6p2RRr4FJJqYVZ6bcyfWZMHa6qDNca3OCoqmtdEwg/jnFXwKKXwyb5jjRlx6G9o9JpI2GuDTvabtBRWhlATiZLWt6DR9wxUlLUGnew7lsShjzeIThOJQscA1mcK3TO41dSGUgqf7LPG0KB7BmINOtlnjaFpdc8wowvWsIY1W8Wgt/4C7w2oNZPAWyMGPexRdpXuWGPEoAdeMGmJxsLMlF2lO1dMAq/0qaHRZDHoQclOoZ6hMY29V8qu0t0C8o/UbBJ4JWvTqCZ/bCr+3qCewbWmJpRdpbPG0KCegViDqnTWGJpW9wwPbX4cBGuqgzXVwRodeirIPi+m0MSh7/vW4agiOdnX9wvlZ+lNa7K7jjac7OfXQPQa80rqPxr39wx4+Abd36nG7xnyKF+bdmn4nmFXNHzPsCsa7hnKgzXVwZrqePKawrRA8UucRlM3R9Fwld46TcUQGelskj37QqmxN0012zM8QNNslR4Jo58q2amme4bNY2x9tBT3DDuk4Z5hVzSt7hlm8xVVsoY1rNkyh5tqVAyINUMBnXBStTZ4GsitJg46fnBWvVONas5CrxMG+9l/YHoTYw2eBnK9TQC9YSaDwjpRaIyHZrBfWB5l9wwN7FSdBk8DOdXM46CTCUp3qlnNajaPslnI7AEyNXg2ybmmMlXJNBBrcg2eTaLV4Gkg1uSa9vYM5PEP4U+dORr9f/kAAAAASUVORK5CYII=" alt="" />aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAEcAAACfCAIAAAAkv1MKAAAEY0lEQVR4nO2cTXKjOhDH+1JUKVyGKkhxFBaYqeIIb+1NIAtuwWZwvPE7AzWTCR+TDW8hQAKJiaeeidJt/asXoq2P/lmyIhQBDBQF/1AUmP5ad5GlwiNLhUeWCo+IUnX9Oz2Drn/vXr4xeMy4S0qfkgcYNX3aPweTiyXnrn/v+vOBQZA/BwDAvp365wAeDsnjMg+vdlSQz1U9HPLRH+TvXa6U0jR3HVXb/W5PCYPHrPu9SMvO0XIfWHzi6XPMwM/GBIicuQ8AQT5VxfOf4yCpeIbsccqc+wDAkmp0yqXmDGpzV9k2FW9V1Du1LYkdzkp7q1BE8eow95YatC6tb+7/UokvCeZm2PSVLzN8QHVK2ByTvis2qDTNXUfVtH1TJQxYXPVN23+PGUDw1PZNlcRZ37R9077EDPysb9rcB57om7Z/8oOnxafccn+qqmlfYsbiqm+yAFjyvV3Wv8ipTWubu8qgEY0BADA/YGOr/ZM/9b2fjwWqZB5G/pp5m6p9maqX6/+QStvcdVRvTUfP4NdbS8+IUr3+augZ/Hx9o2dEqf6lKKJ3IqYD2EWWCo8sldAldSEsVJ+bXpS8Rah17ypLJaSj2pKlupU4FY+yCKdbNCli4ZTcEtUldfknC1K5FJikEkEX4ZQuQjkk4Z8I5M8FlcinVPFJkvtqdkpBLwKas11SF8IwBF2hdSnTI1AJUEPFry+pC+C6i0nva1LNWNKFMgLHi4lALqcfgZzfYF+Fusniw9lizBAWqo9PFOlXGYHoZanwyK7Z8Ygo1Q+KItpXpgPYRZYKj+6KamtrBYnuigq56FItRhu/4UW+iIdhWGwtFOF8646dSmCNUDSoxt0jwUKDarikrhuGrrpliVJiDlzsklGiEjMhEaolBvKlxQCD2KcchvkCc0cNlNcW9ESUyvR20C6CmqIsFR5ZKjz6A1UZOQAA3vHzormVNqnKyEEJVNf1H6iOHjhR+Zmh3FB0qSJHAjh64ESRN59GQDkKoa4X/XL0Rg70fSUhzFAUqOoycpyolOc9ClR1GTmO5zmr3xd2qro+eiBz0KHCi7GSNAJxTuJaQc3HHtI/TBu6uzU7YhGlMr0dtIuI7geaDmAXWSo8ujsq/kgMyv9kbVKh/h/qJpWJh1ZuJrpU6jmmVDzygnIUbpxjItBXmnNMJKiUc0w0qNbnmIhQKQ+L0qHCi7GS/hwTdinnmEjo7tbsiEWUyvR20C4i2lemA9hFlgqPLJXQ/by5iCbVlizVrWTfx2Tfx/RV3lxk38dk38dk38d0K1kqPLJrdjwiSmV6O2gXQd0O9MxS4TFLhccsFR6zVHgM6naIGDjxZXRlIbDQW3vS0nSgf00lx330wct0HtOB/j1VW3jgRhVPhEe9B5ONv6sydp34UsYu+MWWB5FNs0WVOiz0GO+fDQ8eE3Pg0YfVrKB6sNiCSsx7Gx4sJo3A1aygevAY8D4BWEzfqgeX0V1b0DOiVKa3g3YR0f1A0wHsIppU/wE9xvkezC6W8AAAAABJRU5ErkJggg==" alt="" />aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAEkAAACeCAIAAADxKrAcAAAEI0lEQVR4nO2dQW6bTBiGv0tZolwGCVschQV1JY7wr70J7oJbeFMn3jBnQPxtwKS1NV3AwAwGN5Zihxe+R98CXow1T2YMYjQo9N90ISmlEELCcqXx7DZi2A0TdsNkrm6n01kIcSx/I1bV+Pe6Pa+/UM0qqsPvSxVZ60Mn0T52+GrRcvt9SUTWt+f+Ez/DrTi+Fce34nlt0SqqtuvaukTW18NgEq2oPuUQWETt6VuXrOC52j4EFrmR/rUfU7e4HbcuEbVteiuiFVnrvf6N3aRptykQrcjE/AM9xO181t3a5taG73Kr/hYXbp0T71BV44f77XwWQuRFmRdlvl8HUZkXZV68BBa5UZkXW5eqjTIvtkHwUiVW8FKfEi3JWv8wTqk/rJ1YPrnLp6I59GF1usGtKJ9cNYbcbSNs1VHTvq3bjrUm7LjpJ5r549xOZyHEa35ErHddS369Fog1a7eTEOLnrxyxqsYPuv05nYQQ//98Raw/83UT+Ay6SSmzLBs6PH6uNJ7dRgy7YcJuIyEJ7frhwQ6Tq6GUEsot9oi8WG3WIr1hDY6b0fQktO0wGQgVuG7kxQOhAsctCW19+FXbvaECx03Wra+uGqGn+qs3lFKCubXEntFD/SGk28UVsT8Ecrvx7gbldjPshgm7YTJXtwyfQbfr6uOH3TBhN0zY7VO4eI42nkOT66GUY3VLQpvI9jxj/iMJ7cvZrd6wZpxuFebcjrGndnpDBY6bOWNQP2X3hgoYt06nVBq9YbML4zblfpvY3Gunrdpuq9Qb1ozTrZ29qqhb38Yd5YtQSjlWt4+B3TBhN0zm6navyacHMuiWpmmWZSks7IYJu2HCbuNg42iPBgt/143bqALMrdv8dOcvVLhxiJyNdgzcbecvWh9jJ4VzUyiFjaPbdOSR3BqagdjpqSm4tRbT6zfDrbUB/r1tHO1XppQ0n4tLDZDbwJ1s5y86FxgFlNuNsBsm7IbJXN3uNfn0QAbd5ITnJ68fHj/shgm7YYLk1izcMhdvga3n6qfvNRzU9Vxdetxg13N10cakUoBdFzRIMxBx13NdQVlMr98MN8z1XB1iT/uV4a7nGqD3TsbruTqw24hhN0zm6navyacHMuh2XX38sBsm7IYJu30K/N4i6DwXv7eIOV/C7y1OxI3fW2wYpxu/t/gv2A0TdsNkrm73mnx6IINuaSGzLEsLCVrshlnshlnsNpLah+oVDtvfN3ns9IRgbrFD5EQyLWQaeWSFu0KmReJbtAiSOiRvA+nW+lRKtr+verLxSXxLyYO7kRPJNPLIjZvPbFzVh2Bu+3Chj0kiJ5K7wJ6Em1IiIrJC37X9/WT6zajYqX5mvQMV2k3rH83H8ARzS3z1Pxr1gafd9IwbAJbbzcVumMVumDVXt3tNPj2QQbehAxOA3TD5C8mRzZnEO4/VAAAAAElFTkSuQmCC" alt="" />======》》aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAQwAAAClCAIAAAAmilRWAAAQe0lEQVR4nO2dz27byhXG53l6lwULmq+QhxAgGQTuW3TR6gKygvAReru614tGClAVt05XXbWoN5Hsjbgr2qJIavgmkawkstnFkJzh/CPtiJxzqPNhFtKIkj6dMz/OkBKPWEYikZxivg2QSNAlIPkdiUQyqQJJLVJpmv7zLvPV0jRtZUeBTajjgMK8YpIgwSfUcUBhniBBL9RxQGGeIEEv1HFAYZ4gQS/UcUBh/kCQrJJfsujXK20oz2IWJn8lSNoU6jiYzC9iFiXr+ueukyhetOBJE0GCXqjjoJlfxMygHJpFLNHTGSNtL7cIkvaFOg6y+XUSMcbUgb9OIokMMcuYaGoJGhckd7vPjrbf36dp+pf/Za72Y8yC5PfubZ7a0jR1OzyGxrPg3cbXm19NT1j4fLX7PBudnF0V28xPeaf0rOuz8HS2uz4Lpc1Ef1smDwHJP5JvWPxdPnwXz2S6O4Dk6nnIigBJt1fTk8JEGb5Xo6IrnF4XwWWj+asRYyx8vtq9GrGTs+lpdRv+srlG8/KlTs7mef9o/vlurj3L8HYtjrPGH1n0SJspcfBgXg7aaP55NmJs9Mr83Plp/tDV8zB8vtp9Xk1PWjVphWR798nRLJAsnjH27Md8HH83aBeS3MxqGrLTmXJb7szbfMjCyYrfvp6EbDjLbzCx5XzIGBvNi5fi219PRtMl32B2Wmw8HzLGwuky75SfVW6gv92BG8+CIQ7SxwnPrq094uPocejWvNSWZyFj1necjUpjn7az0zwFrbUDQPL63cPrdw+v//7iGxaP3z28/iFmwYvvead+96CtBhI+iFk1oFWFZ9faCFAGh3g6z1y+91W3NN02v12r48z0kZUxpPZUdhYiDh7McwCYUeLdV9OQ74yKpIThqfi80CC5vwcOiRgErBy1hr1OA0hW07DMk3misEDS8k6uzIL+iawf2QBJMVsqkHRrnuMRhqGBxtlp2VmZRlbTMJwu7+ZDCZuWTFoh2Wx3jra/v0/T9OLtw8Xbh4u/vfgFi3/79uHi7R+fMfbsh4eLtw8Xb9ffBowFL77n2xy6pWmam1lOQxZOlrvNdvdmEjI2erndbZbTyYxbvZqEbDjbbbbzIeM3dpvt7uVw9LLyKG/zYfFSm+3VJAwny91mNmLh9M22+vqVLY23jW934MazUMbB+ZHnk8kV7wknV/lTxEfT49Ct+SK8wlvZZqO8s7xRjbn5WQc1eVhIHi5+KM/NnXz7m7gLSPKxyxhj4XAU5oN493JYGBnOy2FUrpmG6njSh3sByfaqeHn59WshMb5du+PM+ZHLgT4vt5I6lTh4MC/nUV1uTa4226tJWLidjZgIePHBy4/cJSQfN3eOxtdqf76599XSNHU7PIbGs+DdxqHMv5mEv5qs1C1fjuTOPwwZG870V3szCY39BzFpheTDx62j5ZD8+95XS9PU7fAYGs+Cdxs9Nn8ASH76795Xgx/fzlLo3UaPzddA8v7DxtH2+32apj/9a++rpWnqdngMjWfBu40em+cmrZD8/P6jo33Z79M0/dN/vvhqaZq6HR5D41nwbqPH5r8QJNgbinGG2nwNJCmJRErT1AEJ8B+r397eenx3OEIdBxTmFZMECT6hjgMK8wQJeqGOAwrzBAl6oY4DCvMECXqhjgMK840gYYz1C5J1EpmupTYW6Whau8ObUIwzm1CYbwqJkZOOIFnEzHSNP0HCBWuc8WoOjDFWLWyid2ZZppgXm7VV0uFpegQkOiftQ7JOIsaiONbH9MEhsYkgeYQWcTm+q3VNtM5cknmpXtBj8tOBXJCUV5PLv+xXrjLvxKQ5ZgQJFyBIKrEqagEZOwtZzKub+dWjIZE5AQMJ30BUYpI2lsszld3SC5bFnipvUi3qBChfBgGGhMULS2chi/lFjHomkTkBBYlgQEzvi1ge4aJfyl/5uHgTaXmgvgREAYJknUTyyorfNnYWMpqHNnm7IClLLiiEyKUYOjHZcCbRtleDXW62TiIWxzEzPUl9FrSMaQIESSbNwVGSlAcZxs4sy0zmFzGww/YnQKLUK+nE5AEh4ff5+YAoUs/AECQHlHHJpHYq5gESkrkhKUsulITopRg6MdlsuVVsId3Rllv5neIF5eeZl1scJ4Lk0TLuW/ROJYkwI/0ISIz1Slq2J505V4/ItZkkNh231x645xvEC72vWB8ATV0hSJA88lsS2bxaABtQ0F2QlHVJGGO2eiWdGxayL7eOS5AgebRQmHdC0qBeSeeGhQgSLhTjzCYU5l2QNKlX0rlhIYKEC8U4swmFeSckDeqVdG5YCEV8OxDqOKAw74KkSSmGzg0LoYhvB0IdBxTmCRL0Qh0HFOZdkDSpInFLIh2BrJDUEkYzCQShjgMK8wQJeqGOAwrzBAl6oY4DCvMECXqhjgMK8wQJeqGOAwrzPYUE7i9KDy8U48wmFObBQ2KvoEGQcPkcZ4ZCNtIFVmt3Z5bp5i2VcfwKOCSuChoodkIdyFMcjIVspJ1T9WJpvXAKl2TeVRnHr1yQ3O0+O5r+N1ktq2GhjaOT1zhUd12Ve/KVbcYrebLMYB7ib1URQWK98rOytOIXv0EMdVsCBEk1Rfl1iMbOQugh2d59crSOIXFd+Sk9lmcEYqjbEhxIlKgb91cESVsy1geQrJeRL/ZaEEPdluBAQjOJ2u7vO4LEVkFDts6PV0SAIYa6LcGC5GuL00HMnAuSzXbnaPsuIHGdyq1YXydRFMflkT3EULclQJDId/XaNJlh0UyQfLWcFTQU65XyQRBD3ZZ8ngLWC9mIboUd43ddehlOc2Ucv3JB8nFz52idn91SpUNin9X7LNSnwlGYd0Hy4ePW0WBBop+vP5Yv3HGMM5tQmO8DJEV5OenO0UwjGZJxZhMK8y5I3n/YONp+T9VSQAh1HFCYd0Hy8/uPjvaFIIEh1HFAYZ4gQS/UcUBh3gUJVUshkbiskNQSlqbpjT/d3t56fHc4Qh0HFOYJEvRCHQcU5gkS9EIdBxTmCRL0Qh0HFOYJEvRCHQcU5nsMyeU4YIyxwXlHfnwJxTizCYV5+JCcD/Jfhaqj3R3fy3HQfz5ubm6AjbMyW4wxFowv1W7RxWUwfzkO9O28Cjgkl+MgH+nnAxUT9+A4H8AKdHuCBokW9stxUHRqWdTMX46DIAhg5c4FSZNCEN051cJPkHBBh6Qyp6sTvGL+chwE40touUMDiR64Mr7joDqxB+OxmPT7v+SCBoka+fOBnAQljxXzHBF4OzgXJE0KQbRuMD/8Ngx2EV8pqGVGoAW6PYGCpFS5xlLmDjskYkNouQMPSaHzgXo0J8W3jKrYa0ELdHuCCYnIQLOZRGYJWu6eDgmvltKhVTV08uDgEzXkQLcnBJCITFiPSfIFgywwK2UXJE0KQbTrTpzckk+RCOuVLYPBIFCOTQiSjnU+kHZSRQIkMJqdfYGWO9iQiEOS+u9JlPUYtEC3J0iQWL4REVls9GUXtNy5IGlSLcWvdfkutMh2JliQPFIozLsgaVIIwq91ced4vmDXhGKc2YTCfB8g4TP8kSKCZJzZhMK8C5Im1VL8Wvf47nCEOg4ozLsgaVIIwq91j+8OR6jjgMI8QYJeqOOAwrwLEqqWQiJxWSHJ6kR1tyAIdRxQmCdI0At1HFCYJ0jQC3UcUJgnSNALdRxQmCdI0At1HFCY7zEk+d+L9f6fSlCMM5tQmEcCyTqJmP1/3G3P6D0fWZYBG2eVf7kUCSu71f8fM5g35dqvUECyTqIo0v7gzT04tP957a2gQaKFXfpzPu3vxjXz5lz7lQuSJoUgOrDI/6Ndjz5BwgUdksqcXvM/7rZc+xV4SHjYTNEvrVf+RXQRsyhJxKTf/yUXNEjUyC9iOQlKHivm7bn2KxckTQpBtGxP7HhcM4n0WJkRaIFuT6AgKVWusZS5ww6JK9d+BRoSOb7O5Vb5oNhrQQt0e4IJichAs5nEnWu/ejokvFpKm97yc7gVSeGWrfOJGnKg2xMCSEQmrMck7lz7lQuSJoUgOjNac+C+TqIojiPl2IQg6ViLWNpJFQmQwNCyYjQPLXd9gaSSFfP2fRUkSCzfiIg1gTo7oIekSbWUzg0L6ZCAimxnggXJI4XCvAuSJoUgOjcspC634KxhuxWKcWYTCvN9gITP8EeKCJJxZhMK8y5ImlRL6dywEIr4diDUcUBh3gVJk0IQnRsWQhHfDoQ6DijMEyTohToOKMy7IKFqKSQSlxWSWsJoJoEg1HFAYZ4gQS/UcUBhniBBL9RxQGGeIEEv1HFAYZ4gQS/UcUBh/jghMf2IZZ2Yr6wG/5swFOPMJhTmoUNiqb6RZQRJIZ/jbBFrPwgy/gy4cbUUwwv6FwJIbEP0wJA8wQEMeYKEV/6J40okjYVRGlZLMb4gCLkggVAIgiCpldcVSzWSxsIoj6mWAvPn3AggsV3NqeyE4oXYtnpNtf4KUib49UDxopqdyiqPILGrOqaNl7M3r5aivyAMuSDxXghCln7IoM7U8uXtouyGUkZQLADiRfXxSrGOKi4EiVWuaYLz0LhaivE1QAgNJPq6R5tJMvWu+oxys3USsTiuro/LB5Vn0XLLJZpJPFdLUXQQSPh9foxYraZJkDxFGiR6YZRm1VLMLwhDLkgAFIIwVt/Qra+TSMwK0h1tuaXU75CfZ15uwaverAkQJObCKI+qlkKQPEHWM+zaTBKbjttrD9zLi3/1Pv6uCc0kRqlV0SonQpQsNKqWYnlBAHJBgqdaCsTdT2dC8aW1TSjMuyDBUgiCIPFt4elCYZ4gQS8U48wmFOZdkFC1FBRCHQcU5l2QUCEIFEIdBxTmCRL0Qh0HFOZdkFC1FBKJywpJLWFpmt5sM1/t9vbW47vDaajjgMI8QYK+oY4DCvMECfqGOg4ozBMk6BvqOKAwT5Cgb6jjgMI8QYK+oY4DCvMYIJmJn/eeY4tvNyn07kG0ZRIUP6AeL8v+xcDQqZsvN6sk2nsDD8ksZmFyabHuPXwQGqQ4LAaMDWbZzVZO3HocsmCyzjute7r1OMwfOh8yNlz4/iwVk1ZImhSCaNnfehyq+x5TfI+6AYpDZY9W5G6ZBAKM9TgsKHKYt+8ZfUUYMCTLJAiT8TCfg/O9kRZfsaPK4xsP1B5AEW8jhd49mEJd8DCL5WnhfFjJo9G8so335oKkSSGI1oNeTt/LJKiuaEV8pdycD4vEKD2+A91qCr17yNsyCeTlFmODWXY5iZpCUhzPQMsXeEikScAe38Ug52cxyGd2vae3DRAkW+ksS5iMh9F4+cSZBNTk/3RIeLWUdv0tk6ARJNnlJAoma3mnpff0tcGCRLRi92Rcg9WYL/dxIJoLkiaFIFr2J50YcSy3+KNhPJCP8vWenjaYkEh7NAkM7fhQmF8mgbSDQzOTAIAkk86dq0tVZXDoczS0Wbu9FHr3ULT1ODSdZRFfnqhLX2U5YPxCzHtzQdKkWopf6/Jd/ZQItJMk3cQBV0Nh3gVJk0IQUOJbORlv6elpQzHOUJvvAyTnQ3Uxpvf0uKEYZ6jNuyBpUi2F4uu9oY4DCvMuSJoUgqD4em+o44DCPEGCvqGOAwrzLkioWgqJxGWFJCORSJoIEhKpRgQJiVQjgoREqhFBQiLViCAhkWpEkJBINSJISKQa/R9TgnqRWEVF6QAAAABJRU5ErkJggg==" alt="" />

对于mysql来说

名次用临时变量来保存,考虑对于相同的分数名次一样,可以先将表按分数分组,与名次单独查询出来

select @counter:=@counter+1 as rank,t.score from (select @counter:=0,score from user group by score order by score desc)as t

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAKQAAAB1CAIAAABPtd2cAAAHNElEQVR4nO2dzW7bRhCA53nsMwGar6BHKBABskHAfooeYhVQVJiPkORk62IpQFSkdh4ggXVpbF+4t6ItCjmCktiyUktiD+SSy5+lSJlcDuP5sAdxTDq785GUFI1H4DjOy5cvnXUwxv68d2oxGGNrl4OWUicPDsnGBMkm2cVAsnFBskl2MaiUbf+sw099kp0GySbZxUCycaFC9v38v5SxWCwZY+8/O48b9oEGjZNH/pL1gzGWvhy0w80zKtmus2EDADTr9Wfn/YW1DR7c5bABxsGh6Qa3D+2obPeQ5rBs2ZfdHT61vb4XfLPLQ3r3OhIRdrt+ocPu4M0uAOi/XiYfWE/Zs/vvKSMuG8D8xd9sWq/dxycmjw8bvssLaxuMgwtB9okJXqSsK9ub+WVXh71+aC2DFoD+4loa6e+Bd8h1RwcIDh+0QO9cuo+vOzq0+mkZ22wgkn1+szq/WZ3f2AcaNI5XfHN1frN69dy/gMz2zer85m0Ddg4++vu7j+0DDRrPTL5PWSOQfT9oAUAg6fusvwd695O4umjEFxk22t+DMOEz5geSvVzKZX882gbYfm7zx2tkg7azHfyobNmBP095JtnuyRGTHTmwhOHmuXTZd7N5ylgsl4yxs/HqbLw6G9v7GjSOV97msQna0avx6mzsXt/m4Xh1Nn7bgJ39D/7+7mN+4IejLRB+Q9GDMebN/FO303eXcNXRodWf380GLXAfzO9mg07nyo3onSvvkP4u6N0/Qod4OwsHzk9bu6epGdtsLLDLHtv7mndn23pmbmWR7e0A/MwoTfZsftrit93WwD8DdC/kCxu0gtuzH4zIFg8Mx2sn+/buPmW4zyW/T5a1GIyx9OWgHYqes7/dzlKGJ/vvZS0GYyx9OWgHItnv/l3UYpDsNbK/frtLGYvFgjH27q9FLQZjLH05aIeb59Jlf/l6mzIeFgvG2G//PNRiMMbSl4N2PJBskl2wbEagoXTZP9LnhtPptOopbE6pkyfZuCDZ+SDZMkg2Lkh2Pki2jKhsACDZFaJadqLvqOyhCQDmsLyJbU6VshPSMvSKs8Cw7PSg41QiO+5bkG1bBoBhmgbJFklMi20Z3OfQ5KdBYtBDhWy/gEusvIkUdsXXRrJjhNMS2uIbiUFOZbJF3yQ7G+G0DE0xR0MTDMtODnKqlO37JtnZSLtsXa+JQX9ThWy/Wi9iWqziS1kVKvDIRnplJ8qOlGymrQoTuGQHJvmPEoMcFbL9aj3fdLyKL21VmEAkW9wMHCcGPSqQnViyKS5ABJvyKt96xdMShCPnQHLyVMj2SzMBQFayWd4kioX+B00Gl52hZLO8SRQLyZbhyc5SslneJIqFZMvgsjOUbJY3iWIh2TI82Vmq+MqbRLGQbBkkGxcqZGepepwSSihd9tr96MpWA8nOB8mWQbJxQbLzQbJlkGxckOx8kGwZG8kWPuDB9pGXg012kCvhs8zEoOM4+GQPTX+GKD/UxiRbqB4NPrpODHqokL1pm0XbMqLnZuUgkh0tSjEsWxLkYJYdrqfCAWLZOMqSNmuzGLsJoQCRbNsyxDs2+HXjsSAHqezYHzNgAZFsJ/SHPpb/Yicx6DgOBtnxnppoTTvYZAckPuVFgypk52mzKPypEkpwyk58yosHkcn2b0GSd4qVg0l2znfZamRX21OzWDDJzo0K2dW2WSwWki2DZONChexqe2oWC8mWkaOdZXmTKBaSLYNk40KFbKouxUPpstfuxxib1ITpdFr1FDaHZOeDZJPsekCy80GySXY9INn5INnFyu41vY9tmr3K0iIFl+xRm3+hodYe+VE/gWJwMsEne9TWPMe9JkbdmGQLGeo1udlRW+MPYxlUITtLwWHyWqKnZvUgkh3Kz6itae2R69oXHNqYYJaN0jVm2dDsTSa9pqg3kkMVsrMUHAZr4M9D+G7hkwkq2aO2Jt7GAZq96LWMXrYwUYSXNiLZk9BLsXZTa4/QX9ludalkKehs45IdwCUn3ts5KmRnKTgMpsdnJ7ysRARO2YJiQXDsYkEmW3zriPJZG5Ps5HfZQjiaQBWys1SXqk3T5mCSnRsVsrMUHFadh6yQbJJdD1TIzlJdWnUeskKy18jOUnBYdR6yQrJJdj1QIZuqS/FQuuy1+1HduBpIdj5ItgySjQuSnQ+SLYNk44Jk54Nky3iEbPfbwbF1VEEmO9SBJkiW0BsLd+9SF9syDANl2yRssmMpEtpNxVqMqZCdt52l23KTOhyuJSFFaV+xjVB2YstVNGCTHe3WXfn3Z+dpZxmcjCQ7O/69O3Ito5YtzpVk54FnC/mVLfYujXxLNMJvE6iB7GpbUOfpXRqfPi4wyR6awl2QJ0sQXMk3CZDsskh8Rx10L43eFVXIpt6lSFAhm9pZIoFk54Nky6DepbhQIZvaWSKBZOeDZMug6lJ0lC67vH+AwAPJfkKQ7CcEyX5CkOwnBMl+QpDsJ8T/4PfQaWPUZdMAAAAASUVORK5CYII=" alt="" />

然后将该表与原表关联,为每个人添加名次

合起来的一句sql就是

select u.id,u.username,u.score,a.rank as 名次 from user u,
(select @counter:=@counter+1 as rank,t.score from (select @counter:=0,score from user group by score order by score desc)as t)a
where u.score=a.score;

 aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAQ4AAAClCAIAAAAif4RrAAAQ+klEQVR4nO2dz2/jxhXH5+9pjoEKmv/C/ge9CJAMAvkr0kOrYGUtlpc95LbpKXGArrRAFSR2DkFPLeou1pJ9ERFgESRB4I3gxrbs7NpmD8Mfw5khh7ZFznuj98UcpBElffnefDhDSXxi5+fnhwD0ePQsBqnHo2e2Y3N4eHh4fn7+ePTs8eiZ9XxxJ6ebJ3Z2dvYagCCjYjs2r1+/fn12dsZRsZ4v7sT2uLUgdnZ29gqAIKNiOzavXr16JaICwYntcWtBjCcAQrMNhV7Ww0INSGO2hyKJhEOEColUS4QKiVRLLI7j5yQSyaQEFSNSURT9cBnbalEUNX7QwCDUcUBhvsIkoYJJqOOAwjyh4ohQxwGFeULFEaGOAwrzhIojQh0HFObXiso8/JD5f54rA3ocMC/8J6HSpFDHQWd+GjA/XJifuwj9YNqAJ0WEiiNCHQfF/DRgGiXoTAOBodZIaWcBRqg0L9RxEM0vQp8xJg//RegLfOQzjo6phtAxo3J59a6iXV/fRFH07a9xVfsiYJ3wb9Xb3LdFUVTtcBMaz4J1Gw83Px9tMe/J/OrduL+1c5RuM9nmncKzjne87fHV8Y4nbJb3N2Vyfaj8J/yABZ8kg3j6SCS9BVSOnngsDZNwez7aSk1kQXzZT7u80XEaYtafvOwzxrwn86uXfba1M9oubsNfNlF/kr3U1s4k6e9P3l1OlGdp3q7B0VZ7l/MeYTMpDhbMi0HrT96N+4z1X+qfO9lOHjp64nlP5lfv5qOtRk0aUFld/l7RSlCZPmLs0RfJaP6k2ywqiZn5yGPbY+m22Jm0SY95wzm/fTz0WG+c3GD5lpMeY6w/SV+Kb3887I9mfIPxdrrxpMcY80azpFN8VraB+nZrbjwLmjgIu+PtHJf25LujxqFd80Kb7XiMlb7juJ8Z+3013k5S0FhbGyr7b2/3397u//vpBywYvL3d/zxgnaef8U717lqbARU+lFkxrEV5O8fKOJCGSP50nr/kSCxvqbutf7tGR5tul6WRJPcUDhl5HCyY5xgwrfJ3n488fkhKk+J52/n+wkTl5gY4KvlQYNnY1RyBaqAyH3lZtvSTRgkqDR/wsiyoe1S6yxpU0plTQqVd8xwSz/M0TI63s87ClDIfed5odjnpCfA0ZNKAysXqqqJd39xEUbR3crt3crv3r6d/YMFfT273Tv7xiLFHn9/undzunSw+6jDWefoZ32bdLYqixMxs5DFvOLu6WF0dDj3G+i9WVxez0XDMrR4NPdYbX12sJj3Gb1xdrK5e9PovCo/yNumlL3WxOhp63nB2dTHuM290uCq+fmFL7W3t26258Sxkcajc5clweMR7vOFR8pR819Q4tGs+DW/uLWvjftKZ3SjGXP+stZpsApXbvc+zT/G2PvpL0AYqyQhmjDGv1/eSoXz1opca6U2ywZStonryqFIHfYrK6ih9efH1jaho367Z0Va5y9lwn2RbCZ1SHCyYF/MoL8CGRxero6GXuh33WR7wdMezXW4flfOLy4rG13DfLG9stSiKqh1uQuNZsG5jXeYPh94fh3N5yxd9sfPvPcZ6Y/XVDoeetn8tJg2onJ2vKlqCyk83tloURdUON6HxLFi34bD5taHy9S/Xthr8KLeWSOs2HDZfC5Xfzi4q2vX1dRRFX/94batFUVTtcBMaz4J1Gw6b5yYNqPzvt/OK9v76Ooqir35+b6tFUVTtcBMaz4J1Gw6bf0+ouNFQjDbU5muhEpFIpCiK1vIjfOM2zen09NTiu8MR6jigMF9hklDBJNRxQGGeUHFEqOOAwjyh4ohQxwGFeULFEaGOAwrzm4zKIvR113BrC4XUrR9iTShGW5lQmMeDyjRgugoDhAoXrNHGa0kwxlixuIraGcexZD7frKmCEvcTClQWoc+YHwTqyF47KmUiVO6gaZCN8mJtFaUzkWBeqFx0l/y0IDMqD7k8f63SR45Q4QKESiFWaVUibWeqEvPyZnblEip8g7wylLCxWC4q6xZeMCs+VXiTYpEpQFnTCDAqLJiWdKYqMT8NcM0q1dccQ0MlJyGf8KeBOM7zfiGL2eP5mwgLBvklIAoQKovQF9da/La2M5XWPLSJ3DVUhA20xzNxs0XosyAImO5J8rOg5U0RIFRiYT72wzA7+dB2xnGsMz8NgJ3UPxyV6koWa9UaUeH3+acFvi9/SkOorFHaRZTcKZkHyElcB5WHXJ6/VtVbgKVbCHeUBVhyJ31B8Xn6BRiHilC5s7RHGLVTSiLMSKNARfikXfm4XZ5VAt1ZvfG0PtkgmKp96YoBaAJTQULljt+qiOblct2Agm5G5SGVLFpQ+QJsswQJlTsLhXkzKg+5PL8FESpcKEZbmVCYJ1QcEYrRViYU5s2oPKSSRQtCEeUWhDoOKMybUXnI5fktCEWUWxDqOKAwT6g4ItRxQGHejEqdShanJNIGyICKkTaaVSAIdRxQmCdUHBHqOKAwT6g4ItRxQGGeUHFEqOOAwjyh4ohQxwGFeadRgfsr1fULxWgrEwrzSFApr+JBqHDZHG2aYjrCZVyL6s44Vs2XVOexKxSoVFXxQHFAakGW4qAtpiMcooqXZ6vFW7gE81XVeezKjAqYMhRcNYt9bJysxqF4ACvcE6+f014pFMca8xB/+YoOldJrTQuLLX6hHcSANyVAqBRTlFzzqO1M5QgqYMpQxHH1tabCY0leIAa8KcFBRYq69qhFqDQrbXUCYQey+KdHMIgBb0pwUKFZxXLFlrIqHuIO8POYPMwQA96UYKHy0JJ5EDNnRgVIGYqyD30LO7AIfT8IsvN+iAFvSoBQEe+q9XFizTKaUFmTKqt4SDtQKGQEMeBNyeaHxWoxnbxbIkj73ZhaIlRfnceuzKjgqdgSx4Z53mWh/tAchXkzKnjKUOg+39+UL+txjLYyoTDvDipp0TvhzsZMKTGS0VYmFObNqFDFFhRCHQcU5s2oUBkKFEIdBxTmCRVHhDoOKMybUaGKLSQSlwEVI21RFC3t6fT01OK7wxHqOKAwT6g4ItRxQGGeUHFEqOOAwjyh4ohQxwGFeULFEaGOAwrzzqNyMOgwxlh3tyU/toRitJUJhXksqOx2k1+aymO+OsoHg477lCyXS2CjLcsWY4x1Bgdyd97FpTF/MOio21kVClQOBp1kvO92ZViqh8huF1a4mxM0VJSwHww6aaeSRcX8waDT6XRg5c6MSp0yFO35VZJAqHBBR6Uwv8uTvWT+YNDpDA6g5Q4ZKmr4sigPOsWpvjMY5MsA9xdh0FCRI7/bFZMg5bFgnoMC7zBnRqVOGYrGbSYn55ohn0dZCG2WF2jhbk6gUMmUrbqkeaQclXxDaLlDgkqq3a58ridEOYttfgSDFu7mBBOVPAP1ZhWRKGi5eygqvGJLi4blAIpDhE/dkMPdnBCgkmei9FwlWTyIArN2NqNSpwxFsx7zD8DEj1HyHShs2el2O9I5C6HSsna7wqEqTYCAR73PZqDlDgMq+amK+XsVaYUGLdzNCRIqJd+g5Fms9eUYtNyZUalTscXuDoh3ocW3NcFC5Y5CYd6MSp0yFHZ3IL+zOV/OK0Ix2sqEwrw7qPA5f0NBQTLayoTCvBmVOhVb7O6AxXeHI9RxQGHejEqdMhR2d8Diu8MR6jigME+oOCLUcUBh3owKVWwhkbgMqJQ9nInqgEEQ6jigME+oOCLUcUBhnlBxRKjjgMI8oeKIUMcBhXlCxRGhjgMK886jkvxhmvP/tIJitJUJhXlUqCxCn5X/b33ZM5ynJI5jYKOt8O+decKybvm/1DTmdbm2K0SoLELf95W/rKseIsp/2ToraKgoYRf+blD5Y3XFvD7XdmVGpU4ZihaM8v+kV3NAqHBBR6Uwvxv+t74s13aFBBUePF0Osh0o/EfqNGB+GObLAPcXYdBQkSM/DcQkSHksmC/PtV2ZUalThqJhk/lBqGpWER7L8gIt3M0JFCqZslWXNI+Uo1KVa7tCgIoY5coFWPZgfgSDFu7mBBOVPAP1ZpXqXNvVQ1HhFVuadJh82luQEHRxB/jUDTnczQkBKnkmSs9VqnNtV2ZU6pShaM2u4bR+Efp+EPjSOQuh0rKmgXCoShMg4KFkRWseWu7cQqWQG/32rgoSKiXfoOTrA3mmcASVOhVbWjQsS0UFVHxbEyxU7igU5s2o1ClD0aJhWfICDM7atl2hGG1lQmHeHVT4nL+hoCAZbWVCYd6MSp2KLS0aloUiyi0IdRxQmDejUqcMRYuGZaGIcgtCHQcU5gkVR4Q6DijMm1Ghii0kEpcBFSNtNKtAEOo4oDBPqDgi1HFAYZ5QcUSo44DCPKHiiFDHAYV5QsURoY4DCvObjIruZzCLUH9FN/jflqEYbWVCYR4HKiUVQOKYUEllc7RNA+UnRdqfFteu2KJ5QftCg0rZQF0zKvdwAEOWUOE1iIKgEEltcZaaFVu0LwhCZlQglKEgVIyyuoYpRlJbnOUuFVtg/kQcDSpl149KB6Rgmm9bvJZbfQUhH/yqo2BazFFh3UeolKs4srWX0dev2KK+IAyZUbFehkKUeiohz93iZfV56Q+pxGG+JAimxccLBUOK0BAqpaqaMjgVtSu2aF8DhJChoq6ElFkllu/Kz8g2W4Q+C4Liujl7UHoWLcCqRLMKiIotktaCCr/PzyCL9T4JlftIQUUtzlKvYov+BWHIjAqAMhTaCiCJ5AVYuqVwR1mASTVExOfpF2Dwak0rAoSKvjjLnSq2ECr3Vukn8sqsEujO6o2n9dnlxmoff9eQZhWt5CpthY9JpCzUqthS8oIAZEYFT8UWiIei1oTiC+8yoTBvRgVLGQpCxbaF+wuFeULFEaEYbWVCYd6MClVsQSHUcUBh3owKlaFAIdRxQGGeUHFEqOOAwrwZFarYQiJxGVD54TKublEUffhpbKudnp4uVzE11HFAYZ5QcaShjgMK84SKIw11HFCYJ1QcaajjgMI8oeJIQx0HFObvgApjjFAB21DHAYX5u6GipaUlVPZzZx8TKrpEWveQt1nYSX+UPZhl/dOuplM1n20W7FrfkaLJu6Gi0tIGKvtxvIz/RLNKZSKte0jbtMtYdxwvV/FyHDAvPFjFy9Vi4LHOcJF0FjEQzC8GXvLQbo+x3tT2vhRMGlD59teYN/Eqgqzz21/bQOX5Mn7+JS3ADIm07iFpOR7xcrUYeP5gxueZDI/FwEtZqjBfeB377Z6oiLQ0jsqX8Ztl/Pz7xNab/+pRyQ9aSZSDrtwDKO5NJNK6B12oUyrGgThF7PaE1JSYl7ax3u6PSkZL46jsx3Ecf7efYhMXZpg8ykKGdntpeqQe2+FuNJHWPSRtFnbEBRhj3XF8MPTropKe50DLlxmV/be3vEmcZP1toCKcqHz8fWFiEaI87Sbni9NuMterPc42QKisEkIYY8wLBz1/MLvnrAJqIXBPVLLONlD5Mn5TC5X4YOh3hgvxAKb2uNpgoZK39CClXZUZzGdHOhDNjMreyS1vGSdZD2/tnNYneFQswFbxchZ2vKDrCfFVexxtMFERZg8BD+W8MTc/CzvCYQ7ZrCKhInHSDioffhp/l9pKTlq0qOhmbWjzeHOJtO4hbYuBlxxVC+fl+Zct8mJYWhqwks2sR9iAyjfLG94YY9ltsYH6tl792ATaBynNJdK6B7fN10Dlp5vqBgiVwof3JT2ONhSjDbV5Mypf/3Jd3YCgstuTP2FUexxuKEYbavM1UPnxuroBQWXDG+o4oDBvRuWrn99XN0IFQkMdBxTmCRVHGuo4oDBvRoUqtpBIXAZUyh4mkUhchAqJVEuEColUS/8HHJ/MPFX9J90AAAAASUVORK5CYII=" alt="" />