Question

 With SQL, how can you return the number of records in the "persons" table? 
1. SELECT COUNT () FROM persons
2. SELECT COLUMN (*) FROM persons 
3. SELECT COLUMN () FROM persons  
4. SELECT COUNT (*) FROM persons 

Answer 1

Correct Answer - Option 4 : SELECT COUNT (*) FROM persons 

Concept:

SQL stands for the structured query language. It is used to perform operations like creating, inserting, deleting and modifying the data in the database.

Explanation:

SQL count function:

It is used to count the number of records in the selected table. It is used with the SELECT statement.

Syntax: SELECT count(*) FROM table_name

Here  table_name is given as persons.

So, the number of records in the "persons" table can find out as :

SELECT count(*) FROM persons;