Example: Sorting Employees by Name and Company Seniority Using RANK (Teradata) - Teradata Vantage

Sort employees alphabetically and identify their level of seniority in the company.

SELECT EmployeeName, (HireDate - CURRENT_DATE) AS ServiceDays,
RANK(ServiceDays) AS Seniority
FROM Employee
ORDER BY EmployeeName;

The result may look like the following table.