OraFAQ Forum: SQL & PL/SQL » merging the column in SQL

Home » SQL & PL/SQL » SQL & PL/SQL » merging the column in SQL (PL/SQL Release 12.1.0.2.0 - Production)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

merging the column in SQL [message #644414]

Thu, 05 November 2015 05:00

msinha8
Messages: 43
Registered: March 2014
Location: Hyderbad

Member

Team,

we are trying to achieve from below

 col1                c1               c2
-------           ---------        --------
   x                  A            <<null>>
   x               <<null>>            B

to below functionality through oracle sql query :-

 col1                c1               c2
-------           ---------        --------
   x                  A                 B

any inputs for this?

Regards

Report message to a moderator

Re: merging the column in SQL [message #644418 is a reply to message #644414]

Thu, 05 November 2015 05:45

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

MAX and GROUP BY.

Report message to a moderator

Re: merging the column in SQL [message #645121 is a reply to message #644414]

Fri, 27 November 2015 00:37

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Any feedback?

Report message to a moderator

Re: merging the column in SQL [message #645651 is a reply to message #645121]

Thu, 10 December 2015 08:15

msinha8
Messages: 43
Registered: March 2014
Location: Hyderbad

Member

Hi Michel,

Thanks for your help.

It Helped!!

Regards

Report message to a moderator

Re: merging the column in SQL [message #645652 is a reply to message #645651]

Thu, 10 December 2015 08:22

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So post your solution for future readers.

Report message to a moderator

Previous Topic:	Fiscal Year data counts
Next Topic:	Join on TABLE OF NUMBER passed as a parameter to a function

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 25 11:03:53 CDT 2026