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.
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.
