文档介绍：:抽出部门,平均工资,要求按部门的字符串顺序排序,不能含有"humanresource"部门,employee 结构如下:employee_id, employee_name,depart_id,depart_name,wage答:select depart_name, avg(wage)from employeewhere depart_name <> 'human resource'group by depart_nameorder by depart_name-------------------------------------------------------------------------- SQL 数据库:Test(num INT(4)) 请用一条 SQL 语句返回 num 的最小值,但不许使用统计功能,如 MIN,MAX 等答:select top 1 numfrom Testorder by num--------------------------------------------------------------------------:一张表为 Customer,含字段 ID,Name;一张表为 Order,含字段 ID,CustomerID(连向 Customer 中 ID 的外键),Revenue;写出求每个 Customer 的 Revenue 总和的 SQL 语句。建表 create table customer(ID int primary key,Name char(10))gocreate table [order](ID int primary key,CustomerID int foreign key references customer(id) ,Revenue float)go--查询select , sum( isnull([Order].Revenue,0) )from customer full join [order]on( [order].customerid= )group by ,sum() from order,customer =customerid group by , sum( )from customer full join orderon( = )group by 数据库(10)a tabel called “performance”contain :name and score,please 用 SQL语言表述如何选出 score 最 high 的一个(仅有一个)仅选出分数,Select max(score) from performance仅选出名字,即选出名字,又选出分数:select top 1 score ,name from perorder by scoreselect name1,score from per where score in/=(select max(score) fromper).....4 有关系 s(sno,sname) ame) sc(o,grade)1 问上课程"db"的学生 noselect count(*) from c,sc where ame='db' and o=oselect count(*) from sc o=(o from c ame='db')2 成绩最高的学生号select sno from sc where grade=(select max(grade) from sc )3 每科大于 90 分的人数select ame,count(*) from c,sc where o=o >90 group by ameselect ame,count(*) from c join sc on o=o >90 group by ame数据库笔试题*建表:dept:deptno(primary key),dname,locemp:empno(primary key),ename,job,mgr,sal,deptno*/1 列出 emp 表中各部门的部门号,最高工资,最低工资select max(sal) as 最高工资,min(sal) as 最低工资,deptno from