EmpId EmpSalary LastName SalaryRank ----- --------- -------- ---------- 1 1,000,000 Moran 1 3 100,000 Smith 2 2 50,000 Jones 3
FIGURE 2 ListofHighestPaidEmployees table