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
- 4920 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is raw datatype?
What is the simplest tool to run commands on oracle servers?
How to calculate date and time differences in oracle?
How do you bind variables in oracle?
What are operators in oracle?
How to create a testing table in oracle?
Is oracle an open source?
How to set a transaction to be read only in oracle?
What is the sql query to concatenate column values from multiple rows in oracle?
How many anonymous blocks can be defined?
Differentiate between function and procedure in oracle.
What do you mean by a tablespace?
How to create a new table in your schema?
Differentiate between post-database commit and post-form commit?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
