I am trying to find out if there is any way to aggregate a sales for each Book. I realize I can achieve it either by using group-by clause or by writing a procedure. Example:
10 C Language
20 C Language
4 C# 4.0
12 C# 4.0
2 C# 4.0
Is there a way possible to perform the following query without using group by query?
I realize it is possible using Procedure, could it be done in any other way?