Page 1 of 1

sub query

PostPosted: Fri Jun 29, 2012 1:01 pm
by srik246
I have two tables with names empl and dep

Empl has 4 columns

Name emp_No salary dep_no(foreign key)

Dep has three columns

Dep_no(primary key) Dep_name NO_of_emp

Now i want to retrieve sum of salary of each department grouped by depart name.

Re: sub query

PostPosted: Fri Jun 29, 2012 2:56 pm
by NicC
Ok - permission granted to go ahead and try a few things out.

Re: sub query

PostPosted: Fri Jun 29, 2012 7:40 pm
by dick scherrer
Hello and welcome to the forum,

Please do not post the same question in multiple topics. This is not acceptable. The duplicate will be deleted.

What have you coded so far? What went wrong, if anything.

We are here to help you learn, not provide "canned" solutions.