Assume that a table table1 contains the following data:
mysql> SELECT * FROM table1;
6 rows in set (0.00 sec)
How many rows will be returned when the following statement is executed? SELECT DISTINCT col1 FROM table1;
A.
6
B.
3
C.
4
How many rows will be returned when the following statement is executed? SELECT DISTINCT col1 FROM table1;
Assume that a table table1 contains the following data:
mysql> SELECT * FROM table1;
6 rows in set (0.00 sec)
How many rows will be returned when the following statement is executed? SELECT DISTINCT col1 FROM table1;