Oracle
1Z0-882 · Question #68
Consider the query and its output: Mysql> SELECT Language As Lang FROM countrylanguage ->WHERE countrycode ='GBR'; A user wants to have an output as shown: What query would achieve this?
The correct answer is D. SELECT GROUP_CONCAT (Language) As Lang FROM countrylanguage WHERE. See the full explanation below for the reasoning.
Question
Consider the query and its output:
Mysql> SELECT Language As Lang FROM countrylanguage ->WHERE countrycode ='GBR'; A user wants to have an output as shown:
What query would achieve this?
Options
- ASELECT GROUP_IMPLODE (Language) As Lang FROM countrylanguage WHERE
- BSELECT GROUP_CAT(Language) As Lang FROM countrylanguage WHERE
- CSELECT GROUP_CSV(Language) As Lang FROM countrylanguage WHERE
- DSELECT GROUP_CONCAT (Language) As Lang FROM countrylanguage WHERE
How the community answered
(37 responses)- A16% (6)
- B8% (3)
- C3% (1)
- D73% (27)
Community Discussion
No community discussion yet for this question.