With SQL, how can you return the number of records in the "persons" table?

Question

Can anyone tell me how to return the number of records in the "persons" table?

Answer 1

We can use the aggregate function COUNT () can be used to count the number of records in the table. Here is the statement to return the count of all the records in the Persons table:

SELECT COUNT (*)

FROM Persons

To become an SQL expert, you can take up this SQL course by Intellipaat that provides Instructor-led training, and also certification.