Home » MCQs » SQLite MCQs

What is the syntax of SQLite COUNT Clause?

88. What is the syntax of SQLite COUNT Clause?

1. SELECT COUNT(column_name)
   WHERE CONDITION;
2. SELECT COUNT(column_name)
   FROM database_name
   WHERE CONDITION;
3. SELECT COUNT(column_name)
   FROM table_name
   NULL CONDITION;
4. SELECT COUNT(column_name)
   FROM table_name
   WHERE CONDITION;

Answer: D)

SELECT COUNT(column_name)
FROM table_name  
WHERE CONDITION;

Explanation:

The syntax of SQLite COUNT clause is -

SELECT COUNT(column_name)
FROM table_name  
WHERE CONDITION;