Select a single row from two distinct columns
Just INNER JOIN on a subquery:

SELECT  t1.[TicketNo],
        t1.[LocationID],   
        t1.[FreightPay]
FROM [Tkhist1] t1
INNER JOIN (
                SELECT TicketNo,
                       LocationID,
                       MAX(UniqueID) UniqueID
                FROM Tkhist1
                GROUP BY TicketNo, LocationID
             ) sub
    ON sub.UniqueID = T1.uniqueId