Shulou(Shulou.com)05/31 Report--

This article will explain in detail how SQL Server obtains the total number of records while getting data in paging. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

There are two ways for SQL Server to obtain the total number of records of data:

1. First page to get the data, and then query the database again to get the total quantity

two。 Use count (1) over () to get the total number of records

SELECT * FROM (SELECT ROW_NUMBER () OVER (ORDER BY Id DESC) rn, COUNT (1) OVER () AS TotalCount, Id FROM dbo.T_User) aWHERE a.rn BETWEEN 1 AND 5

The second method can not only paginate but also obtain the total number of records. Is one more field, if you get more data at one time, it will waste some traffic.

If the first method is used, the database will be accessed one more time, and the data connection will be closed and opened once, which will consume the database resources.

The second method was started by my colleagues, and then we used it.

Note: at present, it is found that only sqlserver has it, but mysql does not have this effect. If you find something else, you can use it.

This is the end of the article on "how SQL Server obtains the total number of records while getting data in paging". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it out for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.