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

eussusn

• Aug 25th, 2005

 

c

Milan

• Nov 22nd, 2005

 

Only one i.e. Address.

vadivel

• Feb 6th, 2006

 

2 columns

address 1 and address2 columns

vipin

• Apr 1st, 2006

 

Only one column

pramod kumar

• Apr 6th, 2006

 

dont belive anybody.......its only ONE COLUMN "ADDRESS"

shynesh

• May 6th, 2006

 

I think it is a simple question

saurabh

• Jul 24th, 2006

 

Only One Column having full addres(i.e add1+add2+add3)

prasannasoni

 Profile Answers by prasannasoni 

• Aug 18th, 2006

 

Hi ,

only one column of name Address Which contains Records like

address1, Address2,Address2

address1, Address2,Address2

address1, Address2,Address2

And So On

------------------

vijay_agg

 Profile Answers by vijay_agg 

• Jul 26th, 2008

 

Only one column will be retrieved with name Address having data from address1,address2 and address2

rajivgupta780184

 Profile Answers by rajivgupta780184 Questions by rajivgupta780184

• Aug 20th, 2008

 

aNS>IS "C" I.E 3 COLUMN WILL BE RETRIVED FROM THIS QUERY BUT  THEY ALL ARE CONCATENED BY A COMMA SEPERATED VALUE BY AN ALIAS "ADDRESS"
FROM THE EMPLOYEE TABLE.

d.rajjesh

 Profile Answers by d.rajjesh 

• Aug 26th, 2008

 

c.3

Garima

• Aug 23rd, 2012

 

c. 3 columns for sure.