Hi, I have created a SQL Catalog item in UI however I'm trying to retrieve only 10 or so rows from the database. I am using the SELECT TOP/LIMIT clause to choose how many rows I want to retrieve both queries are having errors, I'm not sure what the problem is, does anyone have any ideas? Thank you.
SELECT TOP 10 FROM x
SELECT * FROM x LIMIT 10
Best answer by Albert de Ruiter
Hi
Depending on the underlying database platform there will be different options to limit the number of rows. Therefore I suggest to test the query outside Ataccama on the database directly first.
Kind regards,
Albert
+4Hi
Depending on the underlying database platform there will be different options to limit the number of rows. Therefore I suggest to test the query outside Ataccama on the database directly first.
Kind regards,
Albert
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
