No question at this time
DBA Top 10
1 M. Cadot 16900
2 A. Kavsek 15000
3 B. Vroman 10300
4 M. Hidayathullah ... 8400
5 T. Boles 4700
6 P. Wisse 4400
7 J. Schnackenberg 3500
8 K. Van Nieuwenhov... 2100
9 A. Hudspith 800
9 T. P 800
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48095
Total active users1706
Act. users last 24h8
Act. users last hour0
Registered user hits last week389
Registered user hits last month1490
Go up

Hierarchy Query, Same level and sublevel with sum., count
Next thread: RAC(ASM) with single instance(standby)
Prev thread: Oracle 12c ORDER BY

Message Score Author Date
Level 1 Level 2 Level 3 Count Sum ADMIN 50 1000...... Rupali Bandgar Dec 04, 2017, 11:10
How to write a query without tables and data? ...... Michel Cadot Dec 04, 2017, 11:20
Hello Rupali, "<I>help us to help you</I>"... ...... Bruno Vroman Dec 05, 2017, 11:34

Follow up by mail Click here


Subject: Hierarchy Query, Same level and sublevel with sum., count
Author: Rupali Bandgar, India
Date: Dec 04, 2017, 11:10, 10 days ago
Os info: UNIX
Oracle info: 11G
Message: Level 1 Level 2 Level 3 Count Sum
ADMIN 50 1000
Rupali 30 750
Ashish 20 250

ADMINX 100 2000
Vaishali 75 1500
Anisha 25 500


Level is received from different table
and
Count and sum is received from different table.

How to write query to find out the data in single query
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Hierarchy Query, Same level and sublevel with sum., count
Author: Michel Cadot, France
Date: Dec 04, 2017, 11:20, 10 days ago
Message:
How to write a query without tables and data?

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Hierarchy Query, Same level and sublevel with sum., count
Author: Bruno Vroman, Belgium
Date: Dec 05, 2017, 11:34, 9 days ago
Message: Hello Rupali,

"help us to help you"...

we see what is probably a header with five names and what looks like2 times three lines of data (but not even knowing how to match the data and the header as the it seems that the data contains only 3 columns...

So how can we guess what you mean and how can we guess what you need?
Maybe you can provide a small test case, with a few small tables and an explanation of what you mean by "level is received from a different table" and what is "count" and "sum" received also from another table...

and when you present data, think at typing <pre> before, and </pre> after so that we can see the alignment (example:
LEVEL1 LEVEL2 LEVEL3 COUNT  SUM

Bruno 2 100
John 1
Yoko 3 400
Best regards,

Bruno Vroman.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here