–创建表
create table d_user(
id int(8) PRIMARY key,
name VARCHAR(12),
age int(2)
)
–插入数据
insert into d_user(id,name,age)VALUES(2,“张三”,30);
insert into d_user(id,name,age)VALUES(3,“李四”,40);
insert into d_user(id,name,age)VALUES(4,“赵六”,50);
insert into d_user(id,name,age)VALUES(5,“网吧”,60);
insert into d_user(id,name,age)VALUES(6,“公鸡”,70);
insert into d_user(id,name,age)VALUES(7,“铁蛋”,80);
insert into d_user(id,name,age)VALUES(8,“三毛”,55);
insert into d_user(id,name,age)VALUES(9,“狗蛋”,25);
sql语法:
按照age进行排名
SELECT a.*,@rank:=@rank + 1 AS rank_no FROM (SELECT * FROM d_user ORDER BY age DESC) a, (SELECT @rank:= 0) b
执行结果: