using select statement [message #327830] |
Wed, 18 June 2008 02:42 |
krithi86
Messages: 19 Registered: June 2008 Location: India
|
Junior Member |
|
|
my table description is as follows
EMP_NAME VARCHAR2(50 BYTE)
EMP_ID NUMBER
DEPT_NO NUMBER
PERIOD_NAME VARCHAR2(30 BYTE)
HRSFORWEEK1 NUMBER
HRSFORWEEK2 NUMBER
HRSFORWEEK3 NUMBER
HRSFORWEEK4 NUMBER
HRSFORWEEK5 NUMBER
i should get the result like
deptno empname empid period week1hrs week2hrs week3hrs week4thurshrs week5hrs MONTHLY_HRS
------ -------------------- ----- -------- -------- -------- -------- ------------- -------- -----------
10 Jothika 12 JAN-08 40 40 40 40 40 200
Simran 14 JAN-08 30 40 40 40 40 190
Kajol 15 JAN-08 30 20 40 40 40 170
****** -----------
deptot 560
here 560 is the MONTHLY_HRS's total. how to use select statement to achieve this?
|
|
|
|