|
First Name |
Last Name |
Dept |
Branch |
Years |
Total Salary |
|
Raja |
Sadiq |
Mktg |
PUNE |
1999 |
12000 |
|
Beena |
Mavadia |
Admin |
Delhi |
2014 |
12250 |
|
Seema |
Ranganathan |
R&D |
Kanpur |
2020 |
89000 |
|
Pankaj |
Sutradhar |
Sales |
Ambala |
1999 |
14875 |
|
Shilpa |
Lele |
Admin |
Jammu |
1983 |
20000 |
|
K.Sita |
Narayanan |
Personnel |
Jammu |
1984 |
14875 |
|
Priya |
Shirodkar |
Personnel |
Jaipur |
1984 |
14875 |
|
Parvati |
Khanna |
Mktg |
Mathura |
1986 |
10500 |
|
Hajra |
Hoonjan |
Admin |
Jaipur |
1996 |
9625 |
|
Giriraj |
Gupta |
R&D |
Agra |
1982 |
15750 |
|
Tapan |
Ghoshal |
CCD |
Ambala |
1997 |
4000 |
|
Zarina |
Vora |
CCD |
Lucknow |
1991 |
8750 |
|
Chitra |
Pednekar |
Finance |
Aligarh |
1982 |
24500 |
|
Gita |
Singh |
Finance |
Kanpur |
1982 |
40000 |
|
Dept |
Employee Total Salary |
Max of Total Salary |
|
Admin |
41875 |
22.47% |
|
CCD |
12750 |
9.83% |
|
Finance |
64500 |
44.94% |
|
Mktg |
22500 |
13.48% |
|
Personnel |
29750 |
16.71% |
|
R&D |
104750 |
100.00% |
|
Sales |
14875 |
16.71% |
|
Grand Total |
291000 |
100.00% |
Pivot With Relationship/ Data Modeling
|
Student Registration (Primary) |
||
|
Reg No |
Name |
Add |
|
101 |
Ram |
Meerut |
|
102 |
James |
Delhi |
|
103 |
Anil |
Kanpur |
|
104 |
hari |
Ghaziabad |
|
105 |
Ritu |
Mumbai |
|
Exam Form (Foreign) |
||
|
Reg No |
Subject |
Fees |
|
104 |
B.A |
4000 |
|
102 |
B.COM |
10000 |
|
103 |
B.TECH |
100000 |
|
101 |
BCA |
40000 |
|
105 |
MCA |
100000 |
Create
Table - Ctrl+T
|
Reg No |
Name |
Add |
Subject |
Sum of Fees |
|
101 |
Ram |
Meerut |
BCA |
40000 |
|
102 |
James |
Delhi |
B.COM |
10000 |
|
103 |
Anil |
Kanpur |
B.TECH |
100000 |
|
104 |
hari |
Ghaziabad |
B.A |
4000 |
|
105 |
Ritu |
Mumbai |
MCA |
100000 |
|
Grand Total |
254000 |
Post a Comment