You can translate the question and the replies:

select top 2 * from table

Hi Team, Am looking for to query top few rows from the tables. I used below query select top 2 * from table . Please correct the query. Thanks Saraswathi C
user
29-04-2016 11:03:10 -0400

1 Answer

Hi, The query you are looking for is this: SELECT * FROM test LIMIT 2; or the equivalent: SELECT * FROM test FETCH FIRST 2 ROWS ONLY; One tip, when I doubt about the syntax of a select statement I check it executing the following command in the VQL Shell: HELP SELECT; or I go to the following document: https://community.denodo.com/docs/view/document/Virtual%20DataPort/Denodo%206.0/Advanced%20VQL%20Guide
Denodo Team
29-04-2016 21:39:06 -0400
You must sign in to add an answer. If you do not have an account, you can register here