This basic example will tell you how many rows are in your table: SELECT COUNT (*) FROM Sales; You can also use it to count the number of rows in any result set.