goldeneye4u 0 Newbie Poster

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.