> > >

MySQL MCQs

Is it possible to use group by clause to concatenate strings?

Yes, use SELECT identifier, GROUP_CONCAT(string SEPARATOR ' ') FROM table_name GROUP BY identifier.

No.

Yes, use SELECT identifier, CONCAT (string,'') FROM table_name GROUP BY identifier.

Yes, use SELECT identifier, STRING_CONCAT (string SEPARATOR ' ') FROM table_name GROUP BY identifier.

Answer

Correct Answer: Yes, use SELECT identifier, GROUP_CONCAT(string SEPARATOR ' ') FROM table_name GROUP BY identifier.

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it