Fetch First Row Only

 Add 'Fetch first row only' after the where condition.

Eg:

SELECT *

FROM customer_order_tab

WHERE contract = 'D101'

FETCH FIRST ROW ONLY;