Q:

Write the query to get the branch and branch wise total(sum) admission fees, display it in desending order according to admission fees.

0

Write the query to get the branch and branch wise total(sum) admission fees, display it in desending order according to admission fees.

All Answers

need an explanation for this answer? contact us directly to get an explanation for this answer

Select Branch, SUM(admission_fee) as Total_admission_fees from tblStudent
group by Branch order by SUM(admission_fee) DESC

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

Top 100 SQL server queries Interview questions

This question belongs to these collections

Similar questions


need a help?


find thousands of online teachers now
Get branch wise average admission fees from “tbl... >>
<< Write the query to get the branch and branch wise ...