Nested Query Problem..driving me nuts :-/

Dev Shed Forums Sponsor:

October 21st, 2003, 04:19 AM

ratumeli

Junior Member

Join Date: Oct 2003

Posts: 20

Time spent in forums: < 1 sec
Reputation Power: 0

Nested Query Problem..driving me nuts :-/

Table DRIVINGHISTORY
HISTORYID NOT NULL NUMBER(4)
EMPLOYEEID NOT NULL NUMBER(4)
OFFENCENO NOT NULL VARCHAR2(10)
OFFENCETYPE NOT NULL VARCHAR2(20)
OFFENCEDATE NOT NULL DATE
DEMERITPOINT NOT NULL NUMBER(2)

TABLE DRIVER
EMPLOYEEID NOT NULL NUMBER(4)
FNAME NOT NULL VARCHAR2(15
LNAME NOT NULL VARCHAR2(20
DATEJOINED NOT NULL DATE
YEAREXPERIENCE NOT NULL NUMBER(2)
LICENCENO NOT NULL VARCHAR2(10
LICENCECLASS NOT NULL CHAR(2)
PHONENO NOT NULL CHAR(12)

I'm to list Employee ID, First and last name and Total of thier demerit points for those employees whose demerit points are greater than 9.

Any help would be greatly appreciated.

Last edited by ratumeli : October 26th, 2003 at 05:42 AM.

October 21st, 2003, 05:55 AM

swampBoogie

Contributing User

Join Date: Jan 2003

Location: Paris Uppland

Posts: 2,349

Time spent in forums: 1 Month 4 Days 7 h 27 m 6 sec
Reputation Power: 390

Code:

select d.EMPLOYEEID , d.FNAME , d.LNAME , sum(dh.DEMERITPOINT )
from DRIVINGHISTORY as dh , DRIVER  as d
where dh.EMPLOYEEID = d.EMPLOYEEID 
group by d.EMPLOYEEID , d.FNAME , d.LNAME
having sum(dh.DEMERITPOINT ) > 9

October 26th, 2003, 05:43 AM

ratumeli

Junior Member

Join Date: Oct 2003

Posts: 20

Time spent in forums: < 1 sec
Reputation Power: 0

thanks again...swampboogie.

Viewing: Dev Shed Forums > Databases > Oracle Development > Nested Query Problem..driving me nuts :-/

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

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:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump