sql常见面试.docVIP

五. 数据库部分1、用两种方式根据部门号从高到低，工资从低到高列出每个员工的信息。select * from employee order by deptid desc ,salary asc2、列出各个部门中工资高于本部门的平均工资的员工数和部门号，并按部门号排序创建表：mysql create table employee921(id int primary key auto_increment,name varchar(50),salary bigint,deptid int);插入实验数据：mysql insert into employee921 values(null,zs,1000,1),(null,ls,1100,1),(null,ww,1100,1),(null,zl,900,1) ,(null,zl,1000,2), (null,zl,900,2) ,(null,zl,1000,2) , (null,zl,1100,2);编写sql语句：（）select avg(salary) from employee921 group by deptid;（）mysql select employee921.id,employee921.name,employee921.salary,employee921.deptid tid from employe