Toad World® Forums

TOP Clause in subquery

I have a subquery where I am selecting only the top 50 rows. There seems to be no way to do this through the query builder except to use the FETCH options. However, if I set the FETCH to 50 then the final output will only have 50 rows which is not what I want. I want the top query to use only the 50 rows from the subquery.

I manually input the SELECT TOP 50 .... into the Query pane but whenever I click on "Visualize Query", this gets removed.

Hi Juan,
we currently don't support this feature. We need to investigate whether we can implement it.