The below query is not giving the appropriate results in my program.
Is order by with fetch first row valid.?
WHERE ACCT_ID = '1'
AND ACCT_NBR = '13244'
AND SUR_NAME = (
WHERE ACCT_ID = '0256'
ORDER BY DATE_3 DESC, TIME_3 DESC
FETCH FIRST ROW ONLY