Posted on by goldeneye4u

Required SQL Query for the following table.

Please Provide me the sub Query for the below table that the rows must be unique and make sum of it.

This is the SQL QUERY THAT I AM USING

SELECT Admission_Fee.srno, Stu_Data.clsname, Sum(Stu_Data.adm_fee) AS Gross, Sum(Stu_Data.Final_adm) AS Final, Sum(Balance.Admission) AS Paid
FROM ((Stu_Info INNER JOIN Stu_Data ON Stu_Info.Regdno = Stu_Data.Regdno) LEFT JOIN Balance ON Stu_Info.Regdno = Balance.Regdno) LEFT JOIN Admission_Fee ON Stu_Info.clsname = Admission_Fee.clsname
GROUP BY Admission_Fee.srno, Stu_Data.clsname, Stu_Info.Admn_typ
HAVING (((Stu_Info.Admn_typ)<>"Annual Charges"))
ORDER BY Admission_Fee.srno;

1.png

I Need the Unique rows with sum of duplicate rows.

2.png