Oracle Query Question

Dev Shed Forums Sponsor:

Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here!

January 10th, 2005, 10:19 AM

code.commander

Registered User

Join Date: Sep 2004

Posts: 25

Time spent in forums: 46 m 41 sec
Reputation Power: 0

Oracle Query Question

Hello...

I'm starting to get the hang of this Oracle thing, however, I have a query that I'm having difficulty with.

I have 2 tables with the following information
Table 1
--------
SubGroupId
infoType
infoCount

Table 2
-------
GroupId
SubGroupId

I need to perform a query that will list a total of all of the infoCount information for a given groupId and a given infoType.

For instance, I may have 2 subgroups belonging to a single group id. However, I want to find out the total of the two infoCounts for each different infoType.

Can someone please help?
Thanks!

January 10th, 2005, 10:26 AM

swampBoogie

Contributing User

Dev Shed Intermediate (1500 - 1999 posts)

Join Date: Jan 2003

Location: Paris Uppland

Posts: 1,766

Time spent in forums: 2 Weeks 4 Days 6 h 24 m 8 sec
Reputation Power: 37

Code:

select sum(infoCount)
from table1
where infoType = <yourGivenValue>
and subGroupId in (select subGroupId
  from table2
 where groupId = <yourGivenValue>)

Not sure what you mean by "the total of all of the infocount" though.

January 10th, 2005, 10:35 AM

code.commander

Registered User

Join Date: Sep 2004

Posts: 25

Time spent in forums: 46 m 41 sec
Reputation Power: 0

Thanks swampBoogie. Except I made a minor error in my question. I really do not have a field called "infoCount" rather there is an entry for each subGroupId of a givent infoType. And I need to count up each of these records that apply to each GroupId.

Thank you

Quote:

Originally Posted by swampBoogie

Code:

select sum(infoCount)
from table1
where infoType = <yourGivenValue>
and subGroupId in (select subGroupId
  from table2
 where groupId = <yourGivenValue>)

Not sure what you mean by "the total of all of the infocount" though.

January 10th, 2005, 11:31 AM

code.commander

Registered User

Join Date: Sep 2004

Posts: 25

Time spent in forums: 46 m 41 sec
Reputation Power: 0

Sorry, there was a mistake made earlier...

There is not an infoCount variable available. Rather there is an entry in the table for each instance of the item. So basically there could be 2 items with the same sub group id, and same infoType.

Any suggestions?

January 10th, 2005, 12:53 PM

swampBoogie

Contributing User

Join Date: Jan 2003

Location: Paris Uppland

Posts: 1,766

Time spent in forums: 2 Weeks 4 Days 6 h 24 m 8 sec
Reputation Power: 37

Code:

select count(*)
from table1
where infoType = <yourGivenValue>
and subGroupId in (select subGroupId
  from table2
 where groupId = <yourGivenValue>)

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: