How many columns are retrieved from this query:SELECT address1 || ',' ||address2 ||',' ||address2 "Address" FROM = employee;A. 3B. 2C. 1D. 0

ashok shroff

• Sep 16th, 2005

 

B.2

sam

• Apr 25th, 2006

 

SQL>SELECT address1||','||address2||','||address2 " Address" FROM employee;ADDRESS-----------------------------------------------------------------------------------------------XXXXXXX,XXXXXXXX,XXXXXXXXXX----------------so answer is -----> C.1

Jim Abraham

• May 27th, 2006

 

All the addressed rows in the select statement are concatenated and renamed as "Addresss". So only 1 column will be reflected in the result.

So answer is C

JohnCenzer

 Profile Answers by JohnCenzer 

• Nov 30th, 2006

 

I think there is some confusion between "retrieve" and "return".

The query retreives 2 columns from the table - address1 and address2,

and returns 1 column "Address"