SHOW ROWCOUNT

Displays the current value of the row count.

Syntax

SET ROWCOUNT rowcount_number;SHOW ROWCOUNT;

Example

The following example demonstrates the SHOW ROWCOUNT statement:

SET ROWCOUNT 10;
SHOW ROWCOUNT;

The above query returns the row count value as 10.