摘要:
<!DOCTYPE html><html> <head> <meta charset="UTF-8"> <title></title> <style type="text/css"> .divred { border: solid 1px red; } </style> </head> <body> 阅读全文
摘要:
1、列出至少有一个员工的所有部门名称。SELECT D.DNAME,COUNT(E.EMPNO) FROM EMP E,DEPT D WHERE E.DEPTNO(+) = D.DEPTNO GROUP BY D.DNAME HAVING COUNT(E.EMPNO)>0;SELECT D.DNAM 阅读全文