What word is missing from the following SQL statement?

What word is missing from the following SQL statement?

__________ count(*) from tablename;

(Please specify the missing word using lower-case letters only.)

View Answer

Answer: select

Explanation:

The missing word is select, which is the keyword used to query data from a table in SQL. The select statement has the following syntax:

select column_list from table_name where condition;

The column_list can be one or more columns separated by commas, or an asterisk () to indicate all columns. The table_name is the name of the table that contains the dat

a. The where clause is optional and specifies a condition to filter the rows. The count() function is an aggregate function that returns the number of rows in the table or in a group. Therefore, the complete statement is:

select count(*) from tablename;

This statement will return the number of rows in the table named tablename.

Reference: SQL COUNT() Function – W3Schools, SQL COUNT: The Ultimate Guide To SQL COUNT Function – SQL Tutorial, The SQL Count Function Explained With 7 Examples.

Topic 2, User Interfaces and Desktops