How many rows will be returned when the following statement is executed?

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;

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *