OraFAQ Forum: SQL & PL/SQL » Query

Home » SQL & PL/SQL » SQL & PL/SQL » Query - Urgent (Merged)

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

Query - Urgent (Merged) [message #203381]

Tue, 14 November 2006 23:56

deepak samal
Messages: 29
Registered: February 2005

Junior Member

I am getting data in below format as,

Id Data1 Data2 Data3
10 101
10 201
10 202
10 301
10 302

But I want to get data in below format without using any intermediate Table,

Id Data1 Data2 Data3
10 101 201 301
10 101 202 302

How can i ??

please send me soon please .

regards
deepak

Report message to a moderator

Re: Query- Urgent [message #203389 is a reply to message #203381]

Wed, 15 November 2006 00:15

bala_id
Messages: 27
Registered: July 2005

Junior Member

Hi,

Your logic is perplexing. Please explain in detail
about your requirement.

Report message to a moderator

Query For select - urgent [message #203403 is a reply to message #203381]

Wed, 15 November 2006 00:53

deepak samal
Messages: 29
Registered: February 2005

Junior Member

HI ,

i have again attached a file as this window does not support this format.

please send me the query . its urgent

Attachment: Query.sql
(Size: 0.29KB, Downloaded 463 times)

Report message to a moderator

Re: Query For select - urgent [message #203404 is a reply to message #203403]

Wed, 15 November 2006 00:56

deepak samal
Messages: 29
Registered: February 2005

Junior Member

Sorry ,
the attachement was wrong . i am sending it again.

regards
deepak

Attachment: Query.sql
(Size: 0.31KB, Downloaded 447 times)

Report message to a moderator

Re: Query For select - urgent [message #203414 is a reply to message #203404]

Wed, 15 November 2006 01:40

bala_id
Messages: 27
Registered: July 2005

Junior Member

Hi,
Still your requirement is not proper. Anyway try using the following query. I think this will fullfil your requirement.

SELECT A.DATA1,B.DATA2,C.DATA3 FROM
 (SELECT DATA1 FROM TEST WHERE DATA1 IS NOT NULL) A,
 (SELECT DATA2 FROM TEST WHERE DATA2 IS NOT NULL) B,
 (SELECT DATA3 FROM TEST WHERE DATA3 IS NOT NULL) C

Please revert back, if you have any clarifications on this.

Thanks & Best Regards,
Bala

Report message to a moderator

Re: Query For select - urgent [message #203417 is a reply to message #203403]

Wed, 15 November 2006 01:50

Frank
Messages: 7901
Registered: March 2000

Senior Member

deepak samal wrote on Wed, 15 November 2006 07:53

HI ,

i have again attached a file as this window does not support this format.

please send me the query . its urgent

If you would read the stickies in the Newbie forum, you would see how to format your post so you don't need these attachments.
Furthermore, you would see that it is not polite (or serve any purpose) to state that your requirement is urgent. It is neither our fault, nor our problem you started too late.

[Edit: and on top of that I merged two topics. Please continue in your original thread, instead of opening a new one if it is about the same issue]

[Updated on: Wed, 15 November 2006 01:58]

Report message to a moderator

Re: Query For select - urgent [message #203673 is a reply to message #203417]

Thu, 16 November 2006 00:29

SLakkaraju
Messages: 1
Registered: August 2005
Location: Hyderabad

Junior Member

Deepak,

Try the following query ...

SELECT ID, SUM(NVL(DATA1, 0)) DATA1, SUM(NVL(DATA2, 0)) DATA2, SUM(NVL(DATA3, 0)) DATA3
FROM MYTABLE
GROUP BY ID

Assumed the following:

> MYTABLE has not more than 3 records for each ID.
> Each record for a given ID, no two records have value
for the same DATA# column.

If this wasn't your requirement, do let me know.

HTH,

Shankar Lakkaraju

Report message to a moderator

Previous Topic:	Use of TEMP segment
Next Topic:	using variable inside a stored proc

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 04:40:23 CST 2024