Advertisement

06.09.2003 at 03:57AM PDT, ID: 20641477
[x]
Attachment Details

Oracle 7 - Need a query

Asked by arogyarajxavier in Databases Miscellaneous

Tags: oracle, 7

I am having followin records

RjrNo      RjrDate      ProdCode      DisecNo            Qty      UnitPrice      ChNch

G102      8/6/03      20            750/102/pp      2      1750            Ch
G102      8/6/03      20            750/102            1      2300            Ch
G102      8/6/03      20            750/102/pp      1      1750            NCh
G102      8/6/03      29            750/4/102      1      1960            NCh
G102      8/6/03      29            750/4/102      1      1960            Ch
G100      7/6/03      29            750/4/102      10      1960            Ch
G101      7/6/03      29            750/4/102      1      1960            Ch


Expected Output for Rjrno = G102

Disecno            Ch             Nch

750/102/pp      1750            1750
750/102            2300            0
750/4/102      1960            1960

we are need for Query for the above output
Start Free Trial
[+][-]06.09.2003 at 04:14AM PDT, ID: 8680859

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.09.2003 at 04:59AM PDT, ID: 8681084

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.09.2003 at 06:47AM PDT, ID: 8681831

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.09.2003 at 07:26AM PDT, ID: 8682176

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Databases Miscellaneous
Tags: oracle, 7
Sign Up Now!
Solution Provided By: andrewst
Participating Experts: 3
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32