Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (55.6k points)

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

1 Answer

0 votes
by (119k points)

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.

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Nov 21, 2020 in SQL by Appu (6.1k points)

Browse Categories

...