Limit Clause SQL for ORACLE not working

Hi all,

I am trying to do something simple. I am using an input tool to connect to an sql database. The tool works just fine. However, when I add a limit clause to the end of my SQL to restrict the number of records being pulled in the sql errors. Am I doing something wrong here? I also tried the Fetch syntax but that does not seem to work either. Any help would be appreciated.

Connectors

Database Connection

Accepted answers

BrandonB

Can you try using the limit option in the configuration window rather that in your query?

All comments

BrandonB

Can you try using the limit option in the configuration window rather that in your query?

jaipersr

I completely missed that. Thank you for reminding me of its existence. But I still think its weird how the limit clause does not work in the input tool. Is this a known error that I just have to accept?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703