Saved Bookmarks
| 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; |
|