Question

question 19 (2 points) saved
listen
to count the number of rows in a table, use the sql construct ______.

1. select *
2. select count *
3. select count(*)
4. all the above

Explanation:

To determine the correct SQL construct for counting rows in a table:

• Option 1: SELECT * retrieves all columns and rows of a table, not count rows.
• Option 2: SELECT COUNT has incorrect syntax (missing parentheses around ).
• Option 3: SELECT COUNT() is the correct SQL syntax to count the number of rows in a table, as COUNT() counts all rows (including those with NULL values in columns).

Answer:

1. SELECT COUNT(*)