|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
July 14th, 2005, 07:38 AM
|
|||
|
|||
|
Hierarchical query
Hi,
I am developing report application using java. My requirement is: The report should display different regions. Each region may contain multiple customer set. Each customer set may contain multiple Tech Group. Each Tech Group may contain multiple Role. Each role may contain multiple cost center. Each cost center may contain n-number of employees. Each employee categorized as billable, non-billable and partially billable. I have to count how many employees are billable, non-billable and partially billable. Total of billable,non-billable,partially billable employees in a cost center and grand total in a region. How to built sql query to fetch this data. I am attaching report document with this mail. Please give me response ASAP. Reagrds Praveen
|
|
#2
July 14th, 2005, 07:58 AM
|
||||
|
||||
|
Post your table structures and some sample data (as a SQL script).
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
#3
July 14th, 2005, 08:22 AM
|
|||
|
|||
|
sample data
Hi,
The report gets its data from three tables. 1.EMPLOYEE. 2.EMPHRDATA. 3.TIMECARD. I will get region names from EMPHRDATA AND TIMECARD(based on the EMP_NO field). Please find the attached sample data and script files for these tables. Regards Praveen
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Hierarchical query |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
