Kbase P57258: How to find the number of records a query will return (SQL-9
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/12/2003 |
|
Status: Unverified
GOAL:
How to find the number of records a query will return (SQL-92)
FIX:
To find out how many records a given query in SQL-92 will return issue a SELECT statement similar to the following:
SELECT COUNT(*) FROM YourTableNameGoesHere WHERE YourWhereClauseGoesHere
This will generate a one column, one row resultset containing the number of records that will be retrieved when you issue a SELECT statement using the same table name and where clause but with your own list of columns.