Home » SQL & PL/SQL » SQL & PL/SQL » Interesting Query
icon14.gif  Interesting Query [message #253924] Wed, 25 July 2007 05:39 Go to next message
tarunj
Messages: 23
Registered: April 2007
Location: Noida
Junior Member
ename sal
..................
ravi 1000
roja 2000
ramana 1000
rakhi 2000
renu 3000

i need o/p as
ravi ,ramana sal is 1000
roja,rakhi sal is 2000
ie having same salaries enames n thier salary
Re: Interesting Query [message #253942 is a reply to message #253924] Wed, 25 July 2007 06:16 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
search for stragg or concat_all.
Re: Interesting Query [message #253952 is a reply to message #253924] Wed, 25 July 2007 06:28 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search also for pivot.
A query is not interesting when it is asked several times per week.
Closed.
./fa/448/0/
Regards
Michel
Previous Topic: alter table with dynamic sql
Next Topic: how to connect default data base in oracle 10g?
Goto Forum:
  


Current Time: Tue Dec 06 14:15:21 CST 2016

Total time taken to generate the page: 0.10144 seconds