Which function is used to display the total number of records from table in a database?
(a)
sum(*)
(b)
total(*)
(c)
count(*)
(d)
return(*)
Answer:
The count(*) function is used to display the total number of records from a table in a database.
Syntax:
SELECT
COUNT
(
*
)
FROM
table_name;
So, the correct answer is (c).