Multiple choice general knowledge sports

How many columns are presented after executing this query: SELECT address1||','||address2||','||address2 "Adress" FROM employee;

  1. 1

  2. 2

  3. 3

  4. 0
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In the given SQL query, multiple columns are concatenated using the string concatenation operator (||) and separated by commas, but the entire resulting expression is given a single column alias "Adress". Therefore, the query returns only 1 column in its result set.

Keep practicing — related questions