ExecuteSQL Show 1 Row of Search Results

I have query that do a find, sort the records, then I want to show only the first record:

ExecuteSQL ( "

SELECT legalType, legalStatus, agreementDate, expiryDate FROM contractHistory WHERE id_productID = ? 
ORDER BY agreementDate DESC FETCH FIRST 1 ROWS ONLY

" ; " | " ; "" ; Product::id )