UsefulGyaan Has Posted the Following On 05-24-2013 10:04 AM:

Problem Statement: There is a table named Employee which has department wise employee details as given below. We want to find out gender-wise subtotals and a grand total for each department. Dept Employee_ID Gender IT E123 M IT E124 M IT E125 M IT E126 M IT E127 F IT E128 F HR E129 M HR […]





Calculating Subtotals Within Groups of Data Using UNION