Skip to main content
Solved

Inline Querier fails on SQL TOP function

J
Forum|alt.badge.img
  • j
Hi All,

 

 

can anyone confirm/deny if the TOP function should work in the InlineQuerier, as in...

 

 

Select TOP 10 * from table1

 

 

I am having no joy so far

 

 

thanks

Best answer by takashi

Hi,

 

 

The InlieQuerier uses SQLite database internally, and SQLite doesn't support "TOP" clause. You can use "LIMIT"" instead.

 

-----

 

select * from table1 limit 10

 

 

Takashi
View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

takashi
Influencer
  • takashiInfluencer
  • Best Answer
  • June 11, 2015
Hi,

 

 

The InlieQuerier uses SQLite database internally, and SQLite doesn't support "TOP" clause. You can use "LIMIT"" instead.

 

-----

 

select * from table1 limit 10

 

 

Takashi
J
Forum|alt.badge.img
  • j
  • Author
  • June 11, 2015
Thanks Takasahi, thats what I needed...

Helpful Members This Week

Community Stats

31,183
Posts
118,190
Replies
38,793
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.