InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 01:09:24 GMT20http://www.sqlservercentral.com/Forums/Topic1403322-391-1.aspx[quote][b]shohelr2003 (1/6/2013)[/b][hr]Dear,I have a table Student(Section, Roll, Subjects, Marks). Now I want to display the results like the following. That means the result will show section and Roll wise Subjects, Marks from the Student table.Please help me to design the query.[code="plain"]Section| Roll | Subjects | Marks------- ----- ---------- -------X 1 A 70 B 60 C 80Y 1 A 75 B 85 C 80Z 1 A 90 B 78 C 80[/code]Regards,Akbar[/quote]untested[code="sql"]SELECT Section.Roll,Subjects,SUM(Marks)FROM StudentGROUP BY Section,Roll,Subjects[/code]Sun, 06 Jan 2013 04:40:19 GMTJ Livingston SQLhttp://www.sqlservercentral.com/Forums/Topic1403322-391-1.aspxDear,I have a table Student(Section, Roll, Subjects, Marks). Now I want to display the results like the following. That means the result will show section and Roll wise Subjects, Marks from the Student table. I am using SQL Server 2008 R2.Please help me to design the query.[code="plain"]Section| Roll | Subjects | Marks------- ----- ---------- -------X 1 A 70 B 60 C 80Y 1 A 75 B 85 C 80Z 1 A 90 B 78 C 80[/code]Regards,AkbarSun, 06 Jan 2013 04:27:44 GMTshohelr2003