Multiple choice technology programming languages

How many columns are presented after executing the below query:SELECT name||','||age||','||address "emp_details" FROM employee;

  1. 1

  2. 2

  3. 3

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

The SQL concatenation operator || joins multiple column values into a single result column. This query combines name, age, and address with comma separators, creating exactly one output column named 'emp_details'. The number of source columns concatenated doesn't affect the result column count.

Keep practicing — related questions