I have a very simple question regarding using the keyword Limit:
This query: select * from myschema.mytable; works fine
This query: select * from myschema.mytable Limit 20; doesn't run
If I right click on the 2nd one and use the "execute the selected text" command, it works fine.
If run a sample data by right clicking on the table name, I do get a sample data back.
My question is: why can't I or what's the proper usage of the 'Limit' keyword?