--得到最先参加工作的3个员工的名单SELECT rownum as SENIOR,tempemp.EName, tempemp.EHiredate
FROM(SELECT EName,EHiredate
FROM Employee
ORDERBY EHiredate) tempemp
WHERE rownum <=3;
TOP N子查询使用order by排序主查询使用ROWNUM伪列限制结果集能显示的行数--得到最先参加工作的3个员工的名单SELECT rownum as SENIOR,tempemp.EName, tempemp.EHiredateFROM (SELECT EName,EHiredate FROM Employee ORDER BY EHiredate...