Find Number of Students and total fees in each class

• lamine.darbouche

  Valued Member

  Points: 66

  More actions

  June 11, 2012 at 5:58 am

  #257778

  Dear Sir,

  I have a student table which consists of four fields, (id, FullName,Class, Fees)

  I want to know how many students I have in each clas and the subtotal Fee in each class.

  Please help.

  Cheers

• Ant-Green

  SSC Guru

  Points: 113563

  More actions

  June 11, 2012 at 6:04 am

  #1499267

  Hi, the below should get you want you need based on your details.

  If not, please follow the second link in my signature on how to post code and data so that we can help you get the solution your after.

  SELECT

  Class,

  COUNT(ID) AS NumStudents,

  SUM(Fees)

  FROM

  SomeTable

  GROUP BY

  Class