easy5 pts · first answer countspostgresqlsql
Counting rows with NULL phones
A table has 1,000 rows, and 200 of them have phone = NULL. What do COUNT(*) and COUNT(phone) return?
Discussion 0
Join free to post in the discussion.
Related questions
- Purpose of a primary keyDatabase Administrator
- INNER JOIN vs LEFT JOINDatabase Administrator
- DELETE vs TRUNCATEDatabase Administrator
- Filtering rows where a value is NULLDatabase Administrator
- COUNT(*) vs COUNT(column)Database Administrator
- What a foreign key enforcesDatabase Administrator
- WHERE vs HAVINGDatabase Administrator
- Logical vs physical backupDatabase Administrator