mysql成绩排名

时间:2023-03-08 23:40:15
mysql成绩排名

关于mysql成绩排名,网上大部分只是order by简单排序,忽略了成绩相同并列名次的问题。

定义了一个表score结构为:

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAboAAABuCAIAAADeTUFfAAAOjElEQVR4nO2dvbKjuBaF9U5dBLzKRERUTdBv0eXUnU42ObmjCe7NOuhy2oFngqnOTtDlU7e6U24gA1u/bIGEQKyvTlE+GBtYiKUtIW2Lvu/7vn9uxadPn37+/LnZ7kAUcNX4JNUq0Zd//vLrP3//b83f5y+/kh7hThAb2yUAYG98/vJr/V/uk9gC2CUAALCAXQIAAAvYJQAAsIBdAgAAC9glAACwYNnlnwAAcHq4dvk7AACcmwC77DORd+95+R6IvKi5jzoP0CoW5SkZ64zC7NK/WSLy7j0v379/55eJsREAraDVGspTMtYZwS53jbzMb29vb29v7+/v7+/vb24OUXDTAa1iUZ6Ssc4Idrlr6GWe5RAFNx3QKhblKRnrjM5tl/dLJarLnfxL/tsDOyy490slBpqOsfVWku5BqzBx9kocJakWq9XoGqET8o0Rzuh+qaoL7FJMhgm7nEOtX7pmttCeyS6DxYm446giR7PL6ajul8qhRtjBd80iUWGXMbhfqupyGa/AXu2S+TgvvV2GC7S5XebTKl/pSWOXa5XUjsp1kBva5aozgl2+LtV4wYYXNPJvOrm+aSohhKgu3eX14v76hteGSW4V7TK37VfzL6UFqHhKvNZAog2xUduUQj2za8UUx1WW+GVsqOOHLx3ejqdrHCV1QV5Op95cysHr952FyS5p9N41omqaUUDz0xHOCHZJ/XGwRbXMjX46llRSZO/0A2liC7NW/PChpX+sej4W9nOc2lnDK9Ly6hqxiVDP7FoxxXGVJX4Zu18qobaH0keXS5TUj8o4Ss/BO8+IRJeTtF3zMl5Sv6iGGeGMYJfkqnSNFmbS4MgIP2nBJcS3AXmZ/1GpB7T1eeySrjRvgK2EembXKlQcsywxy1jnFTwGcZR0RJfOm8t8y3JoSmN8ildlPaR8j+KXEc4IdqnX3E1TVZf7EBFNG/iKctrefOtlllfaXJmn75Jrl8kfe+TWKlCcALtUpfMLHoM4Str7Lt03l/mW5dDUvsuuEU3XNTQYt388whnBLlVZu+ZVp5FLIq+gqyjTWiyNI7gus5VMT8Z9jfFh++RCPXegFUucULs0pctnl2FKKkc1noX75jLfshya9qhnvGef/iIW4Yxgl1otpHQfcRrjzyfpnk7YwPzmRV7jb9++ZRt3Oa4yW1VVtY1Qz31oNS9OsF0+deksYZTcIFolFEdJtRthPDj95iIHb7xloj8Zn3z1fqmqSi+HEc9IHtyp7XL3cC7zyCHmV6QDWsXiOEqqT37cFXGsM4Jd7prxMn/9+nXfBTc/0CoWx1CSNMSfT65drjwj2OWukcMa+JzZAqBVLMpTMtYZBdhl0P7iknfvGfl9EbmPOg/QKhblKRnrjJBNHQAAWBwym/qHP+x/X1uR6yCT8p2HVOnjx4+5j/cwQKtYlKek9YyO1Hc5ckK7nN0mb5VWDONYEc8audJkkwMEOVlplwsThAQxb5dd/++P/rfS7ZKp0kw9/7jW9fWxzXHvHlOr0fX8hsh01fOgKBm/jN1a0d76/tYOV6K9jW+QNa/NomCWjVu7fNzlOKQ0g11Kc4Rd+lXqe1vBhV264Rsi7NIHv9Tx1j+udXvrH9d6MMPh5bTZ8CqmYepHJNobossDgOgyEZpW0vLGpT+6RGOcEjm6VL7BYoGv98k7w0tprRFI0XeZxy5f0WXX/zuugl36o8vHtR5va9ilA+p6J7e/VTyudd22NWk2u8qhXP+41vX1OjSr29uwkfyI3S2FjDfHsjy+VjY3t9D31dODmr0zDmyXf/7o//tX/+GP/sNf57JLGtGYKtnqedKOubWwy5EFfZfW9Ygx9VJHnWgyNrU9Te1S2NaTFXRfj2sty7DVLpXtrXap7YsGpsRpy4ouO9KDica4P7q0FitgIIzeSXNp3RgoaOVNxovWcuhfb3xZT7zS3A/XLvXPvIJLzm0BuzwAa6NL2KUDs++ShpC92y7hlRrOvkuOLbLtknpl3/e2vssFdjl9mfBGl49rfVi7JI3x3+7naowzVep7S2NcL3DAgb+hjZa4D/MZ9mxj3GNqoxHeWqH1YppPxvWuTtVQXfsSlsBU59YK0R7YLqdHPT/OFV36VbLX81Nvdo3ocsTeP+WIK2fd8Mx2afZdvtCMyP2oR4345HjK0SbVQZfki42RmPqT8WmHsuTbokvrox6tbLx2JP9h3orxPDAAzOpZHl2CEGiECLtMS8gAyYDBQcnGXUpglweAmX4Kc8ZD8WgljAc7HjdES5xX6miAGNTGYbpg2lk9fZBdsrMlxefkcRM/Y0ruIwWgZA6TwE2aPZazS8kejmT/S2gFJYPO6JAJ3AAAYHsO2XcJPMhqEHBwaWV2XG5yOAemvFJnPaPldjn+mmfqoUTBdhlrJPYZ0vlAK4I2fNJ8oW2GcZd24l/6DAncrAex0C69v4G+P7vkXz//BJgjWEBYPQ+tDIQxe4cZbJ7ZLhUl+YWBt/6RI4GbVjYeMRK4PZ8zv1gZgU2jy+NbQBjQysB0PdhlGOsvvfINeRK4WVlvlxmiS2UUvn0G1Wz+KDrHagznH0rmKNdUhGQXIwqWWhFaOdC0cjWu0RifxYguD5/ALXLfpeR+qUTS2NJil2rCJfskUFf+KG3iPgnw5ZzSmz1hyWGzn0GrYAQa4yvxFarDJHCzssouN/DKp8UuH0rCJUcFYs8fpYQC6g3v0dfT5Nwfaq0IrXyYEYQ1ToRdzuLsu9QKlbXAeAuSVo5GrzT3w7VLWx1vtoUiR5fbeOXT3Xf5SrjEUWSyAFdGE8eVPqAFWIFWTEav1GJMrW2OxriPUFtk2yX1yr5Pm8DNelpL7bJrNvhRM23v5KhpRWLL0cTJHyXUp22MBqZ+tXaJXs9DKzdm32Xf91ZbNDczObNdGqXu8Anc9OhyTQK3adClEEKkjTJnHvUozySGHE2kEanqMD6soFfjRXsb/3X0Tx8w+xm0CsV0PdhlGJ5Cpb3ljPjyJ3DTOHACtyXX75i37gLWzq84vVYcu3SR8Fj3TXCp230CtyRPxjdgrV3Sigr4gVaILhNypARuVpDArTTKm72bDmgVi/KUXBtd5iV7QicsscTy5EskcCsNeV0BB2gVi/KUtJ7RCfouAViKcPxKD7M3ExRGhARuqYdfwi6DKK+eT8esVoKMwTTX4+H4SHmlLmp02TXDYMvkv50LuwSb4Rkk5LJO65pT4xqLdvwxalEyEqWdCwm7DKK8ej4dplazrWzNNBFaSlil7lB2mabvMnn+tvlZPfax/XTF4zpklJqyQx0gv1gMoFUQHLs0nfHMRmmBzNVxpmU7JqszEmXou9QSLhlzmclEaLKJMS30UHUdH7VWhFY+rNElNURXA9waWp45wFSUnOZiO9Oy7Z9ET8a3Tw/8cCYlG993zdinU1aPXtOxgFZhCKOtra3vEUvOwkmccUwO/OMTlqRkkhkLKHyKn7VWhFZWPH2X1C41r6SxJ6JLiT26PLJdxowuc/60md5a5DUwp/hK/32kkoFWgZjhpKs9ztzmjBRhl1YijLtMnSN41aMeSyI7My9ZUWi1IrTy4IouafzYO2LMHnZJYEWXh8rgglk9AMzg6qPUGuDmR87cEj8PsMvSwLhLPppW/uc51jVW6zwh5ZW6tdHlNrnarMAuAQDZQQK30paSPRzJ/pfQCkoGnRESuAEAAAv0XZaGrAYBB1Mr1zNu81+MuKSUV+qsZ7TWLqfMRMlIZZecUWDTuEX2R4rkTFoFjbj0rDkv8S+98WOQZPAwWZP2t3pu7cpfgrxfqhzjLhUWXxtOmik5JtH4pc0946vnoZWKppU1ZrTGj7BLDUVJ/+Sx8PXylyAtsyaUKRX19ZHwlyDlLtfY5f1SVU2TOH1bdrusr9dWzRSwYF87AVp58VueOQwTjXE76y+9PldCt8Bp2DsJM4dcMgkDzBV22TWi6ZJnu5yZ1XObskI5Jl2RFFLqhwWZxzL9r6aZMqdR6x/Z3RQFS60IrRzY+6dgheEY0aXMAShIVkAjb8tYWvSyp5Yru1uq83XJHpTNeeXcmPlmnNHAYrt8JVHPYZdqUjLz/qTSaCmkaEQv50ybacpsF+G1S+NLdj+XGlqtRTAe8sBYFUhZUo1NbU9Tu3SnerO27KWxWe1S2Z5VzrUkhz6Wp9iQLpnDLh/2pGSOmmR+jVLa6+vNdhH6W6tWhrvtoVNrRWjlY/Z5rsf+4IwUZ98lraddZcxb9rRSM3qluR+uXeqfUe8R6xkNLLNLmRd4YhcJ3JZbgFqlOO7wVwtj9xZgBVpx4EeO8EofobbItkvqlX3f2/ouF9jl9GX+/qLHtV47kChDdDlp9rjWNMBRxXPXJFMzwWwgaEkhFUFv7asO2nUDU6/noZUbf3TpDy3REqcYpU59hm2UKL5dTkX11up2Nm32sJXsnlXOtXtkKMF62bi1QrQHtEu9a3bKCjU1FuvaWZNMH66JwuT7aJoptf5RhKWf2DHQajGh9ndmu1SgnTaaEWlvOSM+murNGHRplL9p2/6hPRnnlHNOCX3tSP7DNKyktji7d8ChvPkV6VgcXUbZviSCS13IAEndAiN9rZ8ks3o2AHYJNia0cX3yljgbGiAGtTWYLph2Vk+PBG7lgeiSD7SKRXlKro0u85I9oROWWGJ58iUSuJWGvK6AA7SKRXlKWs8IfZcAAMACdlka5dXz6YBWsShPSUSXAACwHNhlaZRXz6cDWsWiPCURXQIAwHJgl6VRXj2fDmgVi/KURHQJAADLgV2WRnn1fDqgVSzKUxLRJQAALAd2WRrl1fPpgFaxKE9JRJcAALAc2GVplFfPpwNaxaI8JddGl9vkarMCuwQAZAcJ3EpbSvZwJPtfQisoGXRGSOAGAAAs0HdZGrIaBBygVSzKU9J6RrBLAABgAbssjfLq+XRAq1iUpySiSwAAWA7ssjTKq+fTAa1iUZ6SiC4BAGA5sMvSKK+eTwe0ikV5SlrP6P9Evhf/JM/oGgAAAABJRU5ErkJggg==" alt="" />

mysql随数据库中意添加一些数据。

SELECT * FROM score;

查询结果为:

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAPoAAACYCAIAAABCsmM7AAAKO0lEQVR4nO2dP2/iSBjG/Z0ukZaWng+AtkCRwC39NddEKFWoT0qRFp2UJoLqFGn76KRIqaDZK1IhdDpFF8IuZK7wv7Fn7Nh4Zt4Z5vlpCpYk9vO+/jH+s4CD//7bYmDUHL86TkDeQQwMYwO6Y3g0glsAHIfVJvhXBbe3t0qWA8ARNNC9/q9W0OgVppCXlxeS9baHPDl5AFU0KgS600CenDyAKqC7A5AnJw+gCujuAOTJyQOoAro7AHly8gCqsFj31bTTma6UrJIxdvQ2Ux3jiOWT26Y9gO4mJ1iju1iwzbrXz5b+5mraCSLCRcNFOaP70Zus4g/zDcx+66h1WaO7iM26H/fnx75yoHuseycM099zW3fJLMi/lhVQVmq2ws50JdoZd5kLtAizbLk/jv4s+nE0jed/XFh47TJrJS+uWtifrKadznQacv+s3eV6Abh/cVpybYzWzu3gxCYUUwnLXITxH3+622xSiBQDui9CvhcGdF9NO8kKF2G4kOqeCJE9zNImLY6f4RaXe77wuFmZtZIXV52tIv7BatrJjBCTtw9QmInFNma/Hci3tSyV8CD+JUEYofW1CylBv+6f7vpbUFJqNCPKtr00EjdTrvjJKZ3NK85AKmxQm1xcRSC8kgvJ2weoLrDmM2KqMu8rtk7jQuScpO4RyZZrqvunp9cadS9PLq5CWlrlShsHYCp0rzi34X66mnbC6QnonuznGH/koIiyPXLIn/ssspbFAfJdzh84crvjrAzhYEYyATcrs1byVY2DmWxFYvL2AfLTQXkby7e1LFVhiuHyF/7EwYMZlp1u5U53VFC5R5acHMUBxNMplp9ySk+24ubHZ7bp6W70dJMyayYvrrpwDidO/2JdLQNwp/GSNordE5sgS5U1kM+ZvlgKZR5TiBz8r2pCNjGZwJkLkdYD3ZvCX4Y0BLlt5AFUAd0dgDw5eQBVQHcHIE9OHkAV0N0ByJOTB1AFdHcA8uTkAVTRTHeTnxgHQAcNdG/+cpJwe3v7y+/M/ACgEdAdeAR0Bx4B3YFHQHfgERp1//YP+0qg+yI0+m4AJSzC4juisrdqGXx3A986LkD9t1lajxbdv/7FGGPMuO7xG+kc0z33CSLuM3tGLSu2Lv4sE1P/GQVScrq/vb1tt9vD4dB0KZLZ/Q/2N8ns7t7W4c1OH5vWnbGy1lEk0UZR9+FwuF6v9/t9o6VA9xbw7zwW3jZucl9VbF0045+O60zUvdvtHmE8dG9F7gOdBb0Mvg2/dHZ3rqGlSHTvdrv9fv/5+fnHjx81lwLd1SAJb7CeklWd0tGMXPdut9vr9Z6fn3e7XZ2lQHcVcJ9xTc8U63xaU+H6s4/whtlJ68nP7qnx6/W6zhwvvzLDGGPs25/mdOcPClyakNLPd6ZaCZ+O1U2xdad5HVLf7G5kANAIue6NXGfQHTiC/MrM9+/ff/78WX8p0B04gbbr7tAd2EdR9yNcZ9AdOALeEQk8AroDj4DuwCOgO/CI4EUFjb78AAAqlM3um9eD+cEYI1nvCSQnD6CwEOhu+yBPTh5AYSHQ3fZBnpw8gMJCoLvtgzw5eQCFhUB32wd5cvIACgsh1f3p+ix5q/TZ1dL4NpsPzq8fqbdBs+RZx75cPiVVpO83v5gTtM7gRmxfCKnud6PBXbrN0u2nX5rXw+PVlyAIAsd0X16eJ126G8Xhsx5yPzXZOoMbsX0hpLpnQ9emKttmm9fD5un6zF3dJeHng2A0o2yd9o3YvhA7dNdv3knofuAOXXixlpfnQaDH9Qats76fluhuYid4GrrPLoLB3SH2u3ikrquN9Vpn+5HMxg7dDbXpFHTPBZYcOSQvBvOtc8D1Db3uT9dnptp0Crq/zgdBIvTT9Vkwmr0eHq9G3CUaitnd4EZsXwil7vE5vpHLWEx6eSEIgkDLjKgruXgh8m6ku5Dq1pnciO0LodSdTBqnBnly8gAKC4Hutg/y5OQBFBYC3W0f5MnJAygsBLrbPsiTkwdQWAh0t32QJycPoLAQ6G77IE9OHkBhIdDd9kGenDyAwkKgu+2DPDl5AIWFQHfbB3ly8gAKC2mgO754A/iDstldyXIA0Ap0Bx4B3YFHQHfgEdAdeIQO3WlvUrgInbsNaHaXxw53N9MUY/XkWyfe/tJ9NOie3gLX+C19Y20c2z5cl7Jb9pq+VXWxdYvwtG6oGqP1YIbi9uLu3TU7d7PqDpHuhSAO7iJroUn3aLKgmB7c051xhy6Sgxlz1eRebBmnNMnrnt2Nq+eg7slMvpp2RLkM9lC6b1lNOyckvN4rMwS7ZOd0zwUW0xusR34o5VxDq1Cv+2oacntkzO6fwp0VplNperpvcnKVnjNjdhcpXJmhOuzLLui5dcQpXojkKjFTiNC69AnHJo9q8N9MwCOgO/AI6A48AroDj4DuwCOgO/AI6A48AroDj4DuwCPwxRvAI/C1SmRfBuR5AIWFQHfbB3ly8gAKC4Hutg/y5OQBFBYC3W0f5MnJAygsBLrbPsiTkwdQWIgVus8ugsD8TeJf5wPH7qsqu9Fkdtv4IDB2X1WudYUbTQr38rZoWKH77CI4uxjpvqNvYZvFG8kx3bk7Zd+NkvDzQTCa2dG62QXuq1qp++PVl7OrpYEbWDNxinLvrtmc7ll407qXti65kTd5xyoKodQ9dr2sfSTbzL6RT54eukgOZjTNrDVbZ/nUvqHWfXl5njvq03pocRq6zy6iO8EvL8/Fo+T5wNixu9g666f2DbXule0j2WZWjix5LjB3YFP6jLnW2T+1b6C7Y7q/zgdBNLtzs+ndqPiM+da5MLVvfNadv3wW62LrYNUXIrNndBXyWeuWl+cOTO0bi3Q3LI1Tgzw5eQCFhUB32wd5cvIACguB7rYP8uTkARQWAt1tH+TJyQMoLAS62z7Ik5MHUFgIdLd9kCcnD6CwEOhu+yBPTh5AYSHQ3fZBnpw8gMJCoLvtgzw5eQCFhTTQHV+8AfxB2ez+W2uOWzXVettDnpw8gHmg+5HrbQ95cvIA5lGsO0uaGD0o+2fhcZveUa23PeTJyQOYR73ujGsTM6i74fW2hzw5eQDzaJndoyfN9I5qve0hT04ewDw4mDlyve0hT04ewDx6dU87UuhO4XGb3lGttz3kyckDmAdXZo5cb3vIk5MHMA90P3K97SFPTh7APHLd9/v9G8d+v69eCv5XFTiBRPePj4/I8vF4PB6Po8cfHx8VS4HuwAkkuu/3+4eHh36/PxwOh8Nhv99/eHionuChO3ACie673e7+/n48Hne73W63Ox6P7+/vd7tdxVKgO3ACie7v7+9vb2+TyaTX6/V6vclksl6v39/fK5YC3YETSHQ/HA7b7XYymdzc3Nzc3ES6Hw5VbyyG7sAJ5FdmIuOjk9TtdlvtOoPuwBFwG2HgEdAdeAR0Bx4B3YFHQHfgEdAdeAS+eAN4hJrZHQAngO7AI6A78AjoDjwCugOPgO7AI6A78AjoDjwCugOPgO7AI6A78Ij/AYyzfILhwCxzAAAAAElFTkSuQmCC" alt="" />

我的解决方案:

SET @score = 0;
SET @sort = 1;
SET @num = 0; SELECT id, stundetNo, score, sort
FROM (
SELECT id, stundetNo, score, @num: = @num + 1, IF (score = @score, @sort, @sort: = @num) AS sort,
@score: = score
FROM score
ORDER BY score DESC
) AS t;

结果为:

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAOYAAACBCAIAAABb+VEOAAAIA0lEQVR4nO2dPU/jShSG/Z8uSOs2PT8AbYEiEf8IagoqXN+OFl2JjlS32X51JaRUpGELKoTQvWhBfERzi/hjPDNJbDJzzpzJ+2oK4g2e8555PB4be0/29PRf037/fkVDG9ROTk4UrTIgi7ZNOyEXkEUT1oAsmrDWQfYCgiLQgLXsxcXFv57kcVfQrmkwsl4u6zYeK4F0f3/P0q93sRvhCmBjv0A2UrEbAbJEYh9pX2I3AmSJxD7SvsRuBMgSiX2kfYndCJBdoXmZ5+XcS5dKKYJE+w54lYDsKtEia483F7Jf7nfNLzb/NC/zLGu/9aW+EkF2uPfIkLWVKrJ5UTTfA7Je+2WaZedlntUiQbbtMC/n+icNrSq8eZnnZVlUXyimxu/XAXf3qOx9Tovqlx2uq71ubUQpNa0jzYqp1UXrpf7YO+l9A1jX45D+NvXbiAXZaaGjQIDsvMzrDqdFm9m56gbQIJu1387cATc8unZV/1B9yXKthbOlEWNPVhe6F2fM2wawvsdkZlmbEi9dKqVWGl5ORdrgrke2z5ZM14rDQP91YyebmO1lxMie3YW5xYrZYwB2j3aEPQRkdWnp3h5ZO2zXPudlXpQeke0aGYrskFQPDiBlZOvT7XIDxVp2XhbGpVADjUZPFYxjmO2AtaWC7s44HpSqRtffwqBrpMfCoBvJ5kX0sADW99jPap9+NTFdftXXDJ2rHx9aezrrXAcsN+kn+SoY58xkB+y6gqz2aZhqgPdw+WUZ0cJYdfnVBchKhLcAXD1qed7keH2/rbhvcvkW+70hX2I3gj8lEIl9pH2J3QiQJRL7SPsSuxEgSyT2kfYldiNAlkjsI+1L7EaALJHYR9qX2I2IQRaC2DUMWY+z7B9/KvoGJS8gCwkTkIWECchCwgRkIWEiRfbHk/rOgOy0MJ6r6vtoSjyaFmbQmhG/z8KtD4Osq9UiQvb7P0oppciRrR4z0h7fGvBcfizqvAmgvT9DesyZmeTTBmRfXl5eX18Xi8XQ/Tpm2b/UL5ZZ1g0n9ZBvIT3U5meO+OM4zDcje3x8/PDw8Pn5OWi/ESO7nC+k8Kr0qdXxAC/lxCcF2dFo9AVqI0Z2KZ2D6NV5bcs42AiNCEJ2NBodHh7OZrP39/ee+40eWUkrg1YOL4QcyUJ2NBodHBzMZrO3t7c++40T2fbNJVmzbCXtTbnmOnL4y1Vb9R9BzgYgu6T24eGhz1zrvmOglFLqx990yOpn1GIq/h5XC4zxyld4mZnkE+EsS9Kg5NUX2UG8KiALBVPfOwZ3d3cfHx/99wtkoUAivC8LZCEf2ozsF3hVQBYKJjzJBQkTkIWECchCwgRkIWFyIHvvQxtf7YWgryngLPv4vKBvSimWftMzwhUAkJXa2I0A2cQTnZ4RIJt4otMzAmQTT3R6RnYc2euj5lnL8TV5oq+P9s9/Nh+vJstA9s5ueZkYYOTmfK9K37fTGyul7UaCAILnLQ5kryZHV8ufb0/3g+TXnejnxc+zb1mWZQ2yV5Msm1yGzHgAI1rSria1l+ujwEY6mWxH8PoozBGi9xsBsm2jTfSy3Zzv1chejsOmO4wRDdnWC0cmjWCC9RsJsren+xnBDLcWWf1kmtXTRqSta6SJ3LEwCHSmdiOrHf/hjEeCbJNo0oVBN8vazHRzvhf3CkE3cjleHmC3p/v2xUColLqQDT58j/Eh22SfYqSr5j6ZBj/BeTPSmdjssEMZsTJJwetjJMj+PJtopzPGWXZxOa5Po5Jm2eujZhnThN1cDwUzosw7BkRHeBTINveVCFaQynnHoO16uaQOdWMoJDHdsLW7ToFSqgegpzH0fa44kOUaacmN3QhXAEBWamM3AmQTT3R6RoBs4olOzwiQTTzR6RkBsoknOj0jQDbxRKdnBMgmnuj0jADZxBOdnhFJyOKlcChmBZxlvewHggwBWUiYgCwkTEAWEiYgCwkTKbLTgqVub1vfulOlkL0aUH+1cWsFpFsb4XOqJY698hcdstMiy4uCuNbZmvrWcmrVaRXiuCqFtxXW+dNGhGyVdZbyfM5OKYsSbqtOecicBVlnMEyiQLZ1GQ2y/HPFMDXLAMfCgNQIP7EUyJoLSGpY7CxLmmKVamfUeZnb62/Koy+KI532jkEcs2wUie+vTvzO44/GTSxp2z1kpU2xyzWAWRecuFK4VqOcXYkja9W3jin3/WXf5KKtFG6s7XgTiD8lQMIEZCFhArKQMAFZSJiALCRMQBYSJiALCROQhYQJyELChJfCIWHCf70RaWM3whUAkJXa2I0A2cQTnZ4RIJt4otMzAmQTT3R6RnYbWdo609ZGrVI4YSQ+jayvFB6m+LoT2cuxVsM6mPEIkKWtM61/tCuFk0Xiz4irUnj44us2spfjbG882bUattTF7R+fV1UKllMQ1F0pvGmhSobbB//e2e3ulV0mMdyr0/CReDViVwpfhC6+rgdQ8Uo1gvEgS1Rn2tzonpminmINI9yVwpsqqrVCUhsPsnR1ps2NJrICeO0Y2VApPFTxdUcmHckM0m8EyNLWmV6XZcJI/BlxVAonKL6+08gS15nWPxqVwikj8WnEvskVvvj6TiPLNtKSG7sRrgCArNTGbgTIJp7o9IwA2cQTnZ4RIJt4otMzAmQTT3R6RoBs4olOzwiQTTzR6RkBsoknOj0jkpDFS+FQzOogyx0MBG0WkIWECchCwgRkIWECspAwAVlImIAsJExAFhImIAsJE5CFhOl/RjLlzlM8eNUAAAAASUVORK5CYII=" alt="" />

或者:

SELECT id, stundetNo, score, (
SELECT count(*) + 1
FROM score s
WHERE s.score > score.score
) sort
FROM score

结果为:

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAOQAAACGCAIAAABCCbGLAAAJwUlEQVR4nO2dzYsbRxrG+55/RPcZg3XVIWQXfJibvT4MA5bYQ0IuFiyWT+uPTJxkFALJOOtAhoTFDIYJOLG0woEltzhMQsZMJvYoisfxB0lmjcmONcIfonLoVnd1d43UGlW9b1fN81AEqUeqep+3fqr+cHde7/Hj/4et2+357cx7/w5fx1qrNjU1dfTS7fD11FSt1e0FL33Vrstva61et3td/vvRS7f978b/VGvJA9366OiUqpPadTmSWiv5ySC2eFPaufTx5T+6Pb/dft8Tv/3Nb52PXwq3V/7+ujoPQ9uTJ7uXLn/513M/v3z+4dtX7vobHz789Y3FL1558/e/XPjfP+rNTufO0E5a1UK1KW9pVmcWbwX/3bg4UygUCtVm99biTCFQtdXduDgzc3Ej0VWzWqi2/NcbizOFQrXZ7TWrg2+Fn29Ww9fNamFm8VZX+pj/dmNxJuwqbKdOnRJU8saD1c6mtLP4r086d+//tHXvp617mx9EsP689JK/8XZnq1x5bX8j3r//8Pz7nx/5548vn7t38eov/sZO587Jd/7z6lv/vXlznT0nuhpg1dyUdt5ZWDx3fqF2+kzt9Jn2B57c/I0nT54ul1/d96Cdzp2PPv3s9Qut4xd+ePdKZ2dnt9vtff/92tdf32BPiMYGWDU3pZ2bN9eztEnG3d5+tLr67dWrn9+48c2TJ7vseTDR+GFFQ8vYACuaNe0UoQArmjUNsKJZ02KwLkFQDpTpmHVpaekPTdLYFXTQNAasWk7chvw+jOrBgwcs42oXuxGuAIaMC1hzKnYjgNW42OdYl9iNAFbjYp9jXWI3AliNi32OdYndCGBNqV0vFuttLUMKIQhSrDvgvQRY06KFNT3TXLDue9whXwz/1K4XPS/61L7GcgTW8b3nBta0XIW1WKmEnwOsmsZlWlnb9aI3EAms0YDFelt+J0EVhNeuF4v1eiX4QKWR+P4g4HiPIt1noxJ8WeE66HViI0KIxiBSr9JIDRF5GbzNnPSsAQwbcZzxRo0rmGBtVGQICGBt14uDARuVKKdtEQ8ghNWLPu2pAw5JVHU1eBF8KOVaCmdCI4meUkPIXpQxTxrA8BEdWFnTfGgZUgixp1V/+ZGmdTisWbZ4svb4AchfT3QyitZMRhLZSw+R3JKKWWMA6RHTEWYQYPUlJXpyWNNhq/ps14uVukZY40bGhXWcVI8dgJuwDnau/gaKY9Z2vZI42QlxkbgJglFMcDpg6cBAdpf4JQgRzKu+w4C4kQyHAfFIRh8sjxfA8BGzWc0yrhCC7QRrcFYQO7/RoaE7r9iRvr9J3qUHwShXo3TAqnPEoM+EqRB1DSdYKSNSGHudYMXRSSVCWwCqEaU8j3I8fFwh+C9d6Rb7FR9dYjdy4P9RwLzY51iX2I0AVuNin2NdYjcCWI2LfY51id0IYDUu9jnWJXYjgNW42OdYl9iNWAArBLErK6waV9apDwV9gxwWYIWsEWCFrBFghawRYIWsESmsXz0WxxlgbVQS90BlvZkkP2pUkkFLRvTetzY8DLKhVCKC9fh3QgghyGENbgmSbrUa4175vCh2d770NAvpry2ZSQ6NgHV3d7fX6/X7/XH7VaysV8RdlpVVjSX1ZE8gOdTwNUf83D/w0bCeOHFie3v7xYsXY/WbY1j9NcIWUoW8nCpusKVc7PIPa6lU2gevOYbVl0xA7hV7fCrxMyM0YgWspVLp2LFj6+vrz549y9hv7mG16TggksILIUG2wFoqlY4cObK+vv706dMs/eYT1ugJIrtW1kDSE2vhmeL4DzlNNL4tsPq8bm9vZ1lf1VcDhBBCfPUlHazy/rPSsP7KVYRK4tEr80pmkkOEKytJgxxWVljHIlUAVsiAsl4N2Nraev78efZ+ASukXYTXWQErNJlGw7oPUgVghQwId11B1giwQtYIsELWCLBC1kgB6wMdGvJALQTtTwZX1kc7ffomhGAZ1z0jXAEAVvsauxHA6myK3TMCWJ1NsXtGAKuzKXbPyEGFdW1henAr5PT8JnmKr80eWlglj0SnkSjsw2fXBqbC20vnrlFlsr8853lhMo0ZZ4V1pTy7EqY4TLf5Od7pr84f9jwpv4SR6DOyefbQINSVcuAlMiL91WQmH+30l+e86bnytOOwRs1UZoek+NHagiq/xiPRZ0QKVeHl2qxXXjafydX5w9Pzm3skU/O4+YCVxGqmQc1HotVIuNOXf2CbZw95nhlSEwEEpFLNYB5gpdjzZoM178cACSPLc97sSj+gM3mEasqLiC3tXkwmec0DrER8ZIDVAlJjRmLxK45eBiibz6QimUbGZYV1bWGaio8RsBJGos/ItVlvgOPawrRXXt7pr86XpcsCRCdYyWQaM84Ja3BKTnLNSCivBnie53mzK6SR6DSSvnS1UpZ9EWQyisRtWNnm2ObGboQrAMBqX2M3AlidTbF7RgCrsyl2zwhgdTbF7hkBrM6m2D0jgNXZFLtnBLA6m2L3jABWZ1PsnhE7YMWj2FA+ZXBl1dIPBIUCrJA1AqyQNQKskDUCrJA1ooGVt6JPvJZzukxP/hXV9ZFKJkf35Zq3IhUWYswbCax8tajTVbHtKoAlhIgljasqdjSDnMXuiA8DmGs5x9dYWxQrkVhkgVUZDLnIYOWrRR2b4EhWLbBh5IrDAOpdFd/vnX5lJfeqXI0oS55OrEHc7Xox/SOjTClzwVvqqwEMey/1rpO7aG52xSJNh01mhL80MwWszLWolecnNq2s0llhGDZxVWypHjejiK4GcB0ppmo5hxv4Uz+G0peuaKtiy2lkzB3+UQCyRoAVskaAFbJGgBWyRoAVskaAFbJGgBWyRoAVskaAFbJGeBQbskb4n1zktLEb4QoAsNrX2I0AVmdT7J4RwOpsit0zAlidTbF7Rg46rDQ1lVMbo6rYidJChupJ6zcyvCo2QR0s2rrm/LCS1VSW3yarYifisaMOlqoqtrH6wupM0tY1Z4aVsqZycuNehYYNT7Y+I8qq2LSwRo2irjknrMQ1lZMbVYPmfFlNGUlXxY4OAwwZUcPqeoVB6prKo/Ob+2U1YYS7KrbxsRLjMsIapyQHK2v+l9WYkRFVsU3tl1OZpKtrDlilt7lfVuNGFFWxozMeY3ZE8moAXV3zAwproiq2vyfN/7KaNJK+dCVdSyKoik1c1zwfsBLPsc2N3QhXAIDVvsZuBLA6m2L3jABWZ1PsnhHA6myK3TMCWJ1NsXtGAKuzKXbPCGB1NsXuGQGszqbYPSN2wIpHsaF8KgYrdzAQNEyAFbJGgBWyRoAVskaAFbJGgBWyRoAVskaAFbJGgBWyRoAVskaAFbJGfwK5qQ/FDt9p/wAAAABJRU5ErkJggg==" alt="" />

受到收到