SQL: How many rows in my select statement?

Last Updated on 14 October 2019 by Roberto De Pedrini Sometimes we may need to know in advance the number of records you are about to fetch from the database and show to the user. Just think of applications built for the Web, where a list is shown in groups of elements and buttons allow jumping from one page to another, like this: Here we see how the total number of elements already appears, while the rows are displayed 10 at a time. To fetch the data, we need to define an SQL cursor and load all the fetched rows in a DS array, then managing the positioning page by page. …