If c is a CHAR column that has the case-insensitive latin1_swedish_ci collation what will be the output of the following SQL statement?

The table t has a column c with following contents:

mysql> SELECT c FROM t;

If c is a CHAR column that has the case-insensitive latin1_swedish_ci collation what will be the output of the following SQL statement?

SELECT c, COUNT(*) from t GROUP BY c

The table t has a column c with following contents:

mysql> SELECT c FROM t;

If c is a CHAR column that has the case-insensitive latin1_swedish_ci collation what will be the output of the following SQL statement?

SELECT c, COUNT(*) from t GROUP BY c

A.
Option A

B.
Option B



Leave a Reply 0

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