This is an MSSQL query an incomplete one. I am seeking a complete query.

As we all know if we use aggregate function we must use GROUP BY clause for all SELECT columns and this will affect my desired result. The possible solution is to use sub query. If anyone can help me out with this it would be a great help. https://code.sololearn.com/wUcDgH7lP998/?ref=app

31st May 2018, 3:58 PM
Mohammad Saquib Siddiqui
Mohammad Saquib Siddiqui - avatar
1 ответ
What prevents you from grouping on all other columns if you wanted to get the sums of lt.PRIN and lt.INT ?!
2nd Jun 2018, 1:52 PM
Pe Kie
Pe Kie - avatar