<div>
I think 2 sql statement should be the best, but run using a stored procedure, where 1 output parameter would be used to return the total number of records...
</div>


I think 2 sql statement should be the best, but run using a stored procedure, where 1 output parameter would be used to return the total number of records...

<div>
Option 2: (not recommended)<br />
<br />
select top 50 a.*,b.totcount<br />
from table a, (<br />
select coun(*) as totcount from table) b<br />
<br />
<br />
The above query retrieves the top 50 rows and each row have an additional field totcount containing the total no.of rows present in the table<br />

</div>


Option 2: (not recommended)

select top 50 a.*,b.totcount
from table a, (
select coun(*) as totcount from table) b


The above query retrieves the top 50 rows and each row have an additional field totcount containing the total no.of rows present in the table


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
How do I make an SQL statement retrieve JUST the first 50 rows out of a table but also return the total count of rows that may exist, maybe 400? Should they be two different SQL statments? If so, what would be both statements?<br />
<br />
Thanks<br />
DoughBoy
</div>
</div>


Hi,

How do I make an SQL statement retrieve JUST the first 50 rows out of a table but also return the total count of rows that may exist, maybe 400? Should they be two different SQL statments? If so, what would be both statements?

Thanks
DoughBoy

Get total number of records but not all records based on an SQL query

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.