Limit # of rows

Download Aster
N/A

Limit # of rows

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,

3 REPLIES
Teradata Employee

Re: Limit # of rows

Hi,

The limit syntax you have is correct. Which client are you running this from? Can you copy and paste or type the exact error message when you run the query with a limit?

Enthusiast

Re: Limit # of rows

Hi Osman Mustafa,

 

Is there anything else we can address regarding this request or do you mind if I close this question for now?

Please note, I'll need to close this question after two more business days if we haven't heard back before then.

 

Regards,

Dolletta

Highlighted

Re: Limit # of rows

I am having this same issue!  TD Studio 15.10 connected to Aster 6.2.  Studio doesn't consider "Select * from tablename LIMIT 100" to be valid SQL and will not let me submit the query.  However if I highlight it and submit, it works.