The other option is that if you're not worried about the column name, you simply leave the AS out of the query:

select top 5

o.orderid

, o.customerid

, CONVERT(char(10), o.requireddate, 101)

from orders o

order...