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 |
How do you delete duplicates in sql query using rowid?
What is scope and visibility in PL/SQL?
What is cross join example?
How many types of relationship are there?
will function return more than one value how
how to drop an existing view in mysql? : Sql dba
declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?
Explain the savepoint statement.
table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.
How do I remove sql developer from windows 10?
What is bitemporal narrowing?
How can u find column name from a table which have max value in a row.( not max value)
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)