AnsweredAssumed Answered

Limit # of rows

Question asked by Osman Mustafa on Jan 5, 2017
Latest reply on Mar 27, 2017 by Anthony Stricker

Hi All

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?

 

Thanks,

Outcomes