Get branch wise maximum admission fees from “tblStudent” table order by admission fees descending order.

YasminRadwan26

Save to bookmark

2022-05-13

723

Database, Sql programming, Interview questions, Database Interview-questions, Sql programming Interview-questions,

YasminRadwan26

2022-05-13

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

Select Branch, MAX(admission_fee) as Maxmum_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)