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
14723 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

What are views in sql?

1037

What is a rank in sql?

1007

Explain select statements in sql?

1107

Is sql sequential or random?

1086

Why we use pl sql?

1009

What is file based approach?

999

What are the two characteristics of a primary key?

1032

What is a pdo connection?

1115

Can I learn sql in a week?

1121

What is sql scripting?

1194

Does truncate free space?

1064

discuss about myisam index statistics collection. : Sql dba

1003

What is character functions?

1115

How do I run a sql query?

1082

Which function is used to return remainder in a division operator in sql?

1202