Another way to do that without top would be

Code:
select holidaypay from shiftpaid
    where paidid=(select max(paidid) from shiftpaid)
Although whether CE supports sub-queries in that fashion is a guess on my part...