devxlogo

Variable Returning Matches in a Select Query

Question:
What is the variable that returns the number of matches in a select query?

I thought I’d seen a reference to a variable (something like “_COUNT”) but now I cannot find any reference to it.

Answer:
The _TALLY system variable is what you are looking for. _TALLY holds the number of records that the last query generated.

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.

See also  Five Early Architecture Decisions That Quietly Get Expensive

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.