Kizspy | Question: 32
(Choose 1 answer)
Suppose relation R(A, B) has the following tuples:
AB
1 a
2 b
3 a
4 d
5 e
6 a
7 g
FUOVERFI
The SQL statement to count distinct rows from column B in relation R
A. SELECT COUNT DISTINCT B AS 'Total_rows' FROM R;
B. SELECT (COUNT DISTINCT B) AS 'Total_rows' from R;
C. SELECT DISTINCT B AS 'Total_rows' from R;
D. SELECT COUNT (DISTINCT(B)) AS 'total_rows' FROM R;
