Try this way! create table stest(num int,name varchar(10),value numeric

have table with two columns with datatypes as number and
varchar and the values in
A column like 1,2,3 AND B column values like a,b,c.
now need to display data in a single column as 1,a,2,b,3,c.

Question Posted / saravanan

8 Answers
14355 Views
IBM, Zensar, I also Faced
E-Mail Answers

Answer Posted / saravanan

Try this way!

create table stest(num int,name varchar(10),value numeric
(10,2));

insert into stest values(101,'SARAN',1000.58);
insert into stest values(102,'KALA',1200.18);
insert into stest values(103,'AYYA',3000.40);
insert into stest values(104,'RATNA',4000.57);

SELECT * FROM STEST;

declare @str varchar(2000);
set @str = null;
select @str=ISNULL(@str+',','')+ltrim(STR(num))+','+name
from stest
select @str;

Is This Answer Correct ?

3 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you clear the screen in sql?

1051

What is crud stand for?

984

How do I order by ascending in sql?

989

Name some usages of database trigger?

1004

How to display Row Number with Records in Oracle SQL Plus?

1025

What is the advantage of nosql?

1042

How is data stored in sql?

1041

Explain character-manipulation functions?

1102

What are types of exception?

904

How do I run a pl sql procedure in sql developer?

952

What do you think about pl/sql?

1000

What is embedded sql what are its advantages?

1013

Can you inner join the same table?

976

Can I learn sql in a week?

1043

How do I install sql?

974