<div>
Not working, I'm using InterBase SQL server!<br />

</div>


Not working, I'm using InterBase SQL server!


<div>
Hmm well then I cant help you other, than suggesting using count (like you tried already), as I don't know anything about the IB SQL, sorry. Just reject my answer, and maybe state such things in your question next time.<br />
<br />

</div>


Hmm well then I cant help you other, than suggesting using count (like you tried already), as I don't know anything about the IB SQL, sorry. Just reject my answer, and maybe state such things in your question next time.



<div>
Try<br />
Select Top 100 from mytable<br />

</div>


<div>
<div class="content wysiwyg-content">
I have a huge database and also huge query. I would like to <br />
add a possibility to limit a report of let's say 100 rows.<br />
As I have tried with count() it took a half an hour till I <br />
have had enough and had killed a process. <br />
What to do?
</div>
</div>


I have a huge database and also huge query. I would like to 
add a possibility to limit a report of let's say 100 rows.
As I have tried with count() it took a half an hour till I 
have had enough and had killed a process. 
What to do?

How to limit how many rows I wish to get

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.