1.

Write a SQL statement to list EmpNo, EmpName, DeptNo, for all the employees. This information is should be sorted on EmpName.

Answer»

SELECT empno, empname,deptno FROM emp ORDER BY empname;



Discussion

No Comment Found

Related InterviewSolutions