sql语句 用一条sql语句对姓名进行排序并输出倒数三个人的名字

Question

CREATE TABLE student (
id int NOT NULL AUTO_INCREMENT,
name varchar(32) NOT NULL,
position varchar(32) NOT NULL,
like varchar(32) NOT NULL,
PRIMARY KEY (id)
) ENGINE = InnoDB CHARACTER SET = utf8;
INSERT INTO student ( id, name, position, like ) VALUES
( 1, '金老板', 'A', '嘉然小姐的狗' ),
( 2, '栋栋子', 'A', '夸赞学弟好强啊' ),
( 3, '夏桑', 'B', '嘉然我真的好喜欢你' ),
( 4, '提莫', 'B', '种蘑菇' ),
( 5, '陈三金', 'B', '女装引流' ),
( 6, '金坷垃', 'B', '吸收氮磷钾' ),
( 7, '祖师爷', 'C', '南邮还是宁最卷' ),
( 8, '杂鱼', 'C', '欺负cxy' );

Answer 1

兄弟怎么还是你
select top 3 * from student order by name desc