What does `CONCAT(‘Hello’, ‘ ‘, ‘World’)` return in SQL?

Question

Advanced SQL Developer — Easy

What does `CONCAT(‘Hello’, ‘ ‘, ‘World’)` return in SQL?

Accepted Answer

The `CONCAT()` function in SQL combines the specified strings. In this case, `CONCAT('Hello', ' ', 'World')` will return 'Hello World' because it concatenates 'Hello', a space, and 'World' together.