编辑代码

-- DQL查询语言中的排序查询 关键词是order by;从低到高，从高到低；升序/降序；
create database info;
use info;
create table worker(
    id int,
    name varchar(10),
    age int,
    gender char(1),
    workcity varchar(10),
    entrytime date
);
insert into worker values (1,'张三',28,'F','上海','2020-08-20');
insert into worker values(2,'李四',24,'F','上海','2021-06-25');
insert into worker values(3,'王二麻',27,'M','北京','2020-07-22');
insert into worker values(4,'王五',29,'M','深圳','2022-01-10');
insert into worker values(5,'赵六',32,'F','深圳','2019-07-07');
insert into worker values(6,'钱九',31,'M','北京','2018-04-19');
insert into worker values(7,'孙八',30,'F','深圳','2021-09-17');
insert into worker values(8,'何十',34,'M','北京','2022-03-28');
insert into worker values(9,'九九',26,'M','深圳','2023-08-19');
insert into worker values(10,'零七',24,'F','上海','2021-06-24');
insert into worker values(11,'可可',27,'M',null,'2024-07-21');

-- 语法 select 字段 from 表名 order by 字段1 排序1，字段2 排序2；
-- ASC 升序 DESC 降序；
-- 根据年龄对员工进行升序排序；ASC 也可以不说；
select * from worker order by age ASC;
-- 根据入职时间对员工进行降序排序；
select * from worker order by entrytime DESC;
-- 根据年龄给员工进行排序，如果年龄相同，再按照入职时间降序排序；
select * from worker order by age ASC,entrytime DESC;