SELECT COUNT

Another replacement for the something parameter is COUNT, which can be used in many ways. Command displays the number of rows in the table by passing * as a parameter, which means all rows. As you’d expect, the result returned is 5, as there are five publications in the table.

Counting rows:
SELECT COUNT(*) FROM classics;

Leave a Reply

Your email address will not be published. Required fields are marked *