Many times developers need to order items in a view rather than using a stored procedure. However, adding an order by clause to a view generates an error.
To get around this, use the TOP key word to select the items and add the Order By clause.
To select a list of employees and order the results from oldest to youngest, you would use the following SQL:
Select TOP 100 Percent LastName, FirstName, Title, BirthDate From Employees Order By BirthDate
To retrieve a specific number of rows avoid the PERCENT:
Select TOP 25 LastName, FirstName, Title, BirthDate From Employees Order By BirthDate