Home » SQL & PL/SQL » SQL & PL/SQL » merging the column in SQL (PL/SQL Release 12.1.0.2.0 - Production)
merging the column in SQL [message #644414] Thu, 05 November 2015 05:00 Go to next message
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
Re: merging the column in SQL [message #644418 is a reply to message #644414] Thu, 05 November 2015 05:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

MAX and GROUP BY.

Re: merging the column in SQL [message #645121 is a reply to message #644414] Fri, 27 November 2015 00:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Any feedback?

Re: merging the column in SQL [message #645651 is a reply to message #645121] Thu, 10 December 2015 08:15 Go to previous messageGo to next message
msinha8
Messages: 43
Registered: March 2014
Location: Hyderbad
Member
Hi Michel,

Thanks for your help.

It Helped!!

Regards
Re: merging the column in SQL [message #645652 is a reply to message #645651] Thu, 10 December 2015 08:22 Go to previous message
Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

So post your solution for future readers.

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


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