How To Make Total Row Wise. - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

How To Make Total Row Wise.

Author

Topic

hspatil31
Posting Yak Master

182 Posts

Posted - 2010-07-26 : 00:22:44

Dear All,

I am having following queary and output, in that i want give the Total of FirstDignosis and SecondDignosis,

select SPL.speciality_description
,Emp.FIRSTNAME AS DOCTORNAME, DT.FULL_DATE,
PD.PATIENTCOUNT FIRSTDIGNOSIS,

(SELECT PD.PATIENTCOUNT FROM A_PERFORMANCEDOCTORWISE PD
INNER JOIN D_DATE DT ON DT.DATE_ID = PD.DATEID
INNER JOIN D_DIAGNOSIS DG ON DG.DIAGNOSISID = PD.DIAGNOSISID
WHERE TO_CHAR(DT.FULL_DATE,'DD/MM/YYYY') = (select TO_CHAR(sysdate-1,'DD/MM/YYYY') from dual)
) AS SECONDDIGNOSIS

FROM A_PERFORMANCEDOCTORWISE PD
INNER JOIN D_SPECIALITY SPL ON SPL.SPECIALITYID = PD.SPECIALITYID
INNER JOIN D_EMPLOYEEMASTER EMP ON EMP.EMPID = PD.DOCTORID
INNER JOIN D_DATE DT ON DT.DATE_ID = PD.DATEID
INNER JOIN D_DIAGNOSIS DG ON DG.DIAGNOSISID = PD.DIAGNOSISID

WHERE TO_CHAR(DT.FULL_DATE,'DD/MM/YYYY') = (select TO_CHAR(sysdate,'DD/MM/YYYY') from dual)

Output:

speciality_description FIRSTNAME Date FirstDignosis SEcondDignosis
REGISTRATION Riza 26-JUL-10 12:00 AM 8 5

Now i want output like,

speciality_description FIRSTNAME Date FirstDignosis SEcondDignosis Total
REGISTRATION Riza 26-JUL-10 12:00 AM 8 5 13

Can anybody tell me how make the Total RowWise ?

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2010-07-26 : 00:47:07

seriously Since you are using Oracle, you should post your question over at a Oracle forum. You will get better response & solution there.

I can give you solution in Microsoft SQL Server but not sure it will works under Oracle or not.

KH
[spoiler]Time is always against us[/spoiler]

Sachin.Nand

2937 Posts

Posted - 2010-07-26 : 00:49:27

quote:
Originally posted by hspatil31

Dear All,

I am having following queary and output, in that i want give the Total of FirstDignosis and SecondDignosis,

select *,FIRSTDIGNOSIS + SECONDDIGNOSIS Total from
(

select SPL.speciality_description
,Emp.FIRSTNAME AS DOCTORNAME, DT.FULL_DATE,
PD.PATIENTCOUNT FIRSTDIGNOSIS,

(SELECT PD.PATIENTCOUNT FROM A_PERFORMANCEDOCTORWISE PD
INNER JOIN D_DATE DT ON DT.DATE_ID = PD.DATEID
INNER JOIN D_DIAGNOSIS DG ON DG.DIAGNOSISID = PD.DIAGNOSISID
WHERE TO_CHAR(DT.FULL_DATE,'DD/MM/YYYY') = (select TO_CHAR(sysdate-1,'DD/MM/YYYY') from dual)
) AS SECONDDIGNOSIS

FROM A_PERFORMANCEDOCTORWISE PD
INNER JOIN D_SPECIALITY SPL ON SPL.SPECIALITYID = PD.SPECIALITYID
INNER JOIN D_EMPLOYEEMASTER EMP ON EMP.EMPID = PD.DOCTORID
INNER JOIN D_DATE DT ON DT.DATE_ID = PD.DATEID
INNER JOIN D_DIAGNOSIS DG ON DG.DIAGNOSISID = PD.DIAGNOSISID

WHERE TO_CHAR(DT.FULL_DATE,'DD/MM/YYYY') = (select TO_CHAR(sysdate,'DD/MM/YYYY') from dual)

)T

Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless.

PBUH

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources