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.
Answers were Sorted based on User's Feedback
Answer / kavitha neditunta
select WM_CONCAT(a||','||b)
from tablename;
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / prativa mishra
select rtrim(xmlagg(xmlelement("c",A||' ,'||B||',')).extract('//text()'),',') single_column
from table_name
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / krishna
select rtrim(xmlagg(xmlelement(E,
EMPID||','||NAME||','||'')).extract('//text()') ,',')
empid from emp1
Is This Answer Correct ? | 7 Yes | 3 No |
Answer / sunaksha
select listagg( A||','||B || ',') within group (order by A) from table_name;
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / 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 |
Answer / prativa mishra
select rtrim(xmlagg(xmlelement("c",A||' ,'||B||',')).extract('//test()'),',') single_column
from table_name
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sona mathew
select listagg(c1||','||c2,',')
within group (order by c1||','||c2)
from tab;
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vi.s.senthilkumar
select column1||','||column2 result from tableName;
Is This Answer Correct ? | 2 Yes | 3 No |
What is a transaction?
What are the sql versions?
Is truncate ddl or dml?
what is cross join? : Sql dba
how will be date change into string
Define join and name different types of joins?
Explain two easy sql optimizations.
How can I delete duplicate rows?
How delete all data from table in sql?
What is difference between mysql and postgresql?
Is not equal in sql?
how to use like conditions? : Sql dba