Show a number of rows from a table

Syntax

show <count> from <table reference> [with count]

Parameters

table reference

String. Name of the table to show, optionally qualified by a schema name.

count

Integer. The number of rows to show from the table.

Options

with count

Also show the total number of rows in the table.