Hw2
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Hw2 as PDF for free.
More details
- Words: 62
- Pages: 1
CREATE TABLE EMP ( EmpID INT, EmpName VARCHAR(20), RepAuID INT ) INSERT INTO EMP VALUES(1,'Emp1',NULL) INSERT INTO EMP VALUES(2,'Emp2',1) INSERT INTO EMP VALUES(3,'Emp3',1) INSERT INTO EMP VALUES(4,'Emp4',2) INSERT INTO EMP VALUES(5,'Emp5',4) 1. Display EmpID, EmpName, # of Reporting Employees 2. Display EmpID, EmpName, Who doesnot possess Reporting Employees 3. Display EmpID, EmpName, ReportingPersonName 4. Display EmpID, EmpName, Who doesnot report any employee
