Execute the following SQL Server T-SQL script in Management Studio Query Editor to SELECT the TOP hourly rate employees with TIES:

-- T-SQL TOP function with ties usage

USE AdventureWorks

GO

SELECT   TOP ( 5 ) PERCENT WITH TIES JobTitle = Title,

                                     Department = d.Name,

                                     Gender,

                                     HourlyRate = Rate

FROM     HumanResources.Employee e

         INNER JOIN HumanResources.EmployeeDepartmentHistory edh           

           ON e.EmployeeID = edh.EmployeeID AND EndDate is NULL

         INNER JOIN HumanResources.Department d

           ON edh.DepartmentID = d.DepartmentID

         INNER JOIN HumanResources.EmployeePayHistory eph

           ON eph.EmployeeID = e.EmployeeID

ORDER BY Rate DESC