-
Which clause can be used to sort string values according to a specific collation?
-
- GROUP
- FILTER
- COLLATE
- SORT
- None of these
Correct Option: C
The ‘COLLATE’ operator can be used to sort the string values according to a specific collation. For example, ‘SELECT col FROM tbl ORDER BY col COLLATE latin1_swedish_ci’ sorts by swedish collation.