You can translate the question and the replies:

SELECT TOP

Hi! I am having an issue with this query: SELECT TOP 5 * FROM TABLE It shows the message: Error: Exception parsing query near 5 Thanks
user
25-05-2020 12:47:51 -0400

1 Answer

Hi, I would use the following query to specify the number of records to return: ``` Select * from Table LIMIT 5; ``` OR ``` Select * from Table FETCH FIRST 5 ROWS ONLY; ``` Refer a similar [Q&A](https://community.denodo.com/answers/question/details?questionId=90670000000XcLSAA0&title=select+top+2+*+from+table) for further details. Hope this helps!
Denodo Team
 Edited on: 27-05-2020 08:57:55 -0400
You must sign in to add an answer. If you do not have an account, you can register here