This message is returned when the FETCH FIRST...ONLY clause is not the last clause in the SELECT statement.
Syntactically, the FETCH FIRST...ONLY clause must appear after all other SELECT clauses. In the case of a series of UNIONed SELECT statements, the FETCH FIRST...ONLY clause can be included only at the end of the final query.