SQL-DQL

 

 

select * from user;
select id from user;
select distinct worknum as '工号' from user;
select * from user where age in(23,24,25);
select * from user where age between 22 and 23;

select * from user where name like '___';
select * from user where name like '%颖';

 

select count(*) from user;
select count(idcard) from user;
select avg(age) from user;
select max(age) from user;
select min(age) from user;
select sum(age) from user where address = '广东';

 

 

 

    -- 根据年龄对员工进行升序排序
    select * from user order by age asc ;
-- 对入职时间降序
    select * from user order by entrydata desc ;
-- 对年龄升序，若相同则按入职时间
select * from user order by age asc ,entrydata asc;

 

-- 查询第一页的员工数据，每页显示2条 (起始索引-1) * 每页记录数
select * from user limit 2,2;