Interested to Buy Any Domain ? << Click Here >> for more details...
If I have a select statment which retrives 2 rows, & that
rows have the same data in all the fields except the last
field and I want to merge the 2 rows to be in 1 row with
concatenating the last field which have the different
data.... eg: the 1st row has these fields: A-B-C
the second row has: A-B-X ........ i want to merge the two
row to be in one row like ----> A- B- C,X
- 2 Answers
- 4784 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / murali mohan
Try this...Hope this will give the Required Answer
create table testsamp(a char,b char,c char);
insert into testsamp values ('A','B','C');
insert into testsamp values ('A','B','X');
select a,b,c from(
select a , b,
c||lead(c,1) over (partition by a,b order by a,b) c from
testsamp ) tmp where rownum=1;
Regards,
Murali
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / sreeharibabu g
select max(a),max(b),listagg(c,',') within group ( order by null) from testsamp group by a,b;
| Is This Answer Correct ? | 0 Yes | 0 No |
How to use like conditions in oracle?
What is a SNAPSHOT ?
When can Hash Cluster used ?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
How to update a table row with a record?
Explain what are the advantages of views?
How to create a table interactively?
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?
Is truncate autocommit in oracle?
How to change system global area (sga) in oracle?
How to create a new table in your schema?
Oracle General 
