Shulou(Shulou.com)06/01 Report--

Editor to share with you how to use MySQL variables to achieve a variety of sorting, I hope you will learn a lot after reading this article, let's discuss it together!

-- next I'll demonstrate the implementation of sorting in MySQL-- Test data CREATE TABLE tb (score INT); INSERT tb SELECT 5 UNION ALL SELECT 4 UNION ALL SELECT 4 UNION ALL SELECT 4 UNION ALL SELECT 3 UNION ALL SELECT 2 UNION ALL SELECT1;--1.row_number sort SET @ row_number = 0 position select @ row_number: = @ row_number+1 AS row_number,score FROM tb ORDER BY score DESC +-+-+ | row_number | score | +-+-+ | 1 | 5 | 2 | 4 | 3 | 4 | 4 | 4 | 5 | 3 | 6 | 2 | 7 | 1 | +- -2.dense_rank sort SET @ dense_rank = 0 @ prev_score = NULL SELECT @ dense_rank: = IF (@ prev_score=score,@dense_rank,@dense_rank+1) AS decnse_rank, @ prev_score: = score AS score FROM tb ORDER BY score DESC +-+-+ | decnse_rank | score | +-+-+ | 1 | 5 | 2 | 4 | 2 | 4 | 2 | 4 | 3 | 3 | 4 | 4 | 5 | 1 | +- Sort SET @ row=0 of-+-- 3.rank style @ rank=0,@prev_score=NULL SELECT @ row:=@row+1 AS ROW, @ rank:=IF (@ prev_score=score,@rank,@row) AS rank,@ prev_score:=score AS scoreFROM tb ORDER BY score DESC +-+ | ROW | rank | score | +-+ | 1 | 1 | 5 | 2 | 2 | 4 | 3 | 2 | 4 | 4 | 2 | 4 | 5 | 5 | 6 | 6 | 2 | 2 | 7 | 7 | 1 | +-+ finish reading this article I believe you have a certain understanding of how MySQL uses variables to achieve a variety of sorting, want to know more about it, welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.