Question: Given a t table with a nullable numeric column called num and ten rows total, which is true about the following query? SELECT COUNT (

Given a t table with a nullable numeric column called num and ten rows total, which is true about the following
query?
SELECT COUNT (*), COUNT (num) FROM t
The query will return two columns, the first with value 10, the second with value up to 10
The query will return two columns, both with value 10
The query will fail with a syntax error because COUNT can only be used with a GROUP BY clause
The query will fail with a syntax error because COUNT can only be used with the argument *
 Given a t table with a nullable numeric column called num

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!