1、EMP雇员表中有staffno(工号),sala(薪水),indate(入职日期)3个字段。请按日期分组查询出该天入职雇员名单及其薪水。
我的答案
select staffno,sala ,indate from EMP group by indate,staffno,sala ;
2、EMP雇员表中有staffno(工号),sala(薪水),indate(入职日期)3个字段。SCORE考核成绩表中有staffno(工号),SCORE(分数)两个字段。请查询出没有考核成绩的雇员名单及其入职时间。
我的答案:使用外连接:select EMP.staffno,indate from EMP left outer join SCORE using (staffno) where SCORE.score is null;如果不对,求解正确答案 谢谢!
我的答案
select staffno,sala ,indate from EMP group by indate,staffno,sala ;
2、EMP雇员表中有staffno(工号),sala(薪水),indate(入职日期)3个字段。SCORE考核成绩表中有staffno(工号),SCORE(分数)两个字段。请查询出没有考核成绩的雇员名单及其入职时间。
我的答案:使用外连接:select EMP.staffno,indate from EMP left outer join SCORE using (staffno) where SCORE.score is null;如果不对,求解正确答案 谢谢!
select staffno,sala ,indate from EMP order by indate,staffno,sala ;
2、
select EMP.* from EMP where staffno not in (select distinct staffno from SCORE);
SELECT A.* FROM EPM A,SCORE B WHERE A.STAFFNO = B.STAFFNO(+) AND B.SCORE IS NULL
2.select staffno,indate from emp e where exists(select s.* from score s where s.staffno=e.staffno and s.score is null)
1.select staffno,sala ,indate from EMP order by indate;