Question: Given the following table myTable: table [ [ Given the following table,, ] , [ PKEY , C - 1 , C - 2

Given the following table myTable:
\table[[Given the following table,,],[PKEY,C-1,C-2],[1011,John Abel,0],[1023,Lee Robins,NULL],[1034,Ferguson,322],[1043,Harvey Hansberg,179],[1052,Kohl Kent,7732],[1067,Wendy Stein,0]]
Query: select COUNT(DISTINCT C-2) from myTable;
The results from the above query will be
4
0
None of the choices
0
6
0
5
 Given the following table myTable: \table[[Given the following table,,],[PKEY,C-1,C-2],[1011,John Abel,0],[1023,Lee Robins,NULL],[1034,Ferguson,322],[1043,Harvey

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!