Course Solutions Uncategorized (Solved) : Following Would Produce Sql Error Select Deptdeptid Count Empid Dept Employee Deptid Emp Q29223284 . . . .

(Solved) : Following Would Produce Sql Error Select Deptdeptid Count Empid Dept Employee Deptid Emp Q29223284 . . . .

 

.       Which of thefollowing would NOT produce an SQL error?

a.       SELECT DEPT.DEPT_ID,COUNT(EMP_ID) FROM DEPT, EMPLOYEE WHERE DEPT.ID = EMPLOYEE.ID ;

b.       SELECT * FROMCUSTOMER, SALES ;

c.       SELECT DEPT.DEPT_ID,COUNT(EMP_ID) FROM DEPT D, EMPLOYEE E WHERE D.DEPT_ID = E.DEPT_IDGROUP BY D.DEPT_ID ;

d.       SELECT CUST_ID FROMCUSTOMER, ORDER WHERE CUSTOMER.CUST_ID = ORDER.CUST_ID ;

Expert Answer


An answer will be send to you shortly. . . . .

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post