OraFAQ Forum: SQL & PL/SQL » oracle sql query

Home » SQL & PL/SQL » SQL & PL/SQL » oracle sql query (oracle 10g)

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

oracle sql query [message #613108]

Wed, 30 April 2014 01:42

karthik.m1988
Messages: 4
Registered: April 2014
Location: india

Junior Member

Am beginner in oracle am having a scenario, i need your help to know the answer

having the table EMP_salary

/forum/fa/11853/0/

my output to be like this

/forum/fa/11854/0/

need a query to display is output from the above table.

Attachment: Screenshot-1.png
(Size: 5.29KB, Downloaded 909 times)

Report message to a moderator

Re: oracle sql query [message #613109 is a reply to message #613108]

Wed, 30 April 2014 01:49

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

Please read our OraFAQ Forum Guide and please read How to use [code] tags and make your code easier to read. You have been asked to do this before.

I have no idea what your input data is. You need to provide the CREATE TABLE and the INSERT statements that set up your problem, and whatever SQL you have tried so far. Then perhaps someone can assist.

[Updated on: Wed, 30 April 2014 01:49]

Report message to a moderator

Re: oracle sql query [message #613110 is a reply to message #613108]

Wed, 30 April 2014 01:55

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And you need to feedback and thank people who helped you so much in your previous topic:

http://www.orafaq.com/forum/m/612088/#msg_612088

[Updated on: Wed, 30 April 2014 02:12]

Report message to a moderator

Re: oracle sql query [message #613111 is a reply to message #613108]

Wed, 30 April 2014 02:08

karthik.m1988
Messages: 4
Registered: April 2014
Location: india

Junior Member

Actually first image is not visible , i dont no why

by the way input table EMP_salary is

/forum/fa/11857/0/

Attachment: Screenshot.png
(Size: 8.57KB, Downloaded 900 times)

Report message to a moderator

Re: oracle sql query [message #613112 is a reply to message #613111]

Wed, 30 April 2014 02:10

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

Goodbye.

Report message to a moderator

Re: oracle sql query [message #613115 is a reply to message #613112]

Wed, 30 April 2014 03:12

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

"Pivot" is the keyword you are looking for. Search the board, you'll find numerous examples.

Report message to a moderator

Re: oracle sql query [message #613138 is a reply to message #613115]

Wed, 30 April 2014 08:06

karthik.m1988
Messages: 4
Registered: April 2014
Location: india

Junior Member

thank you littlefoot

got it Smile

Report message to a moderator

Re: oracle sql query [message #613140 is a reply to message #613138]

Wed, 30 April 2014 08:18

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So post your final query.
And feedback in your previous topic.

Report message to a moderator

Previous Topic:	Merge statement
Next Topic:	QEP and Query Reconstruction Technique

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 21:14:04 CDT 2024