InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 04:20:11 GMT20http://www.sqlservercentral.com/Forums/Topic1423210-392-1.aspxBelow is a basic example for Group By[code="sql"]CREATE TABLE #Studentcourseschedule(Department int,Courseid int,studentid int)goinsert into #Studentcourseschedule(Department, Courseid,studentid)values(1,1,1),(1,2,1),(1,3,1),(1,1,5),(1,3,6),(1,1,7),(2,2,1),(2,1,2),(2,3,2)goselect department, COUNT(studentid) Studentcountfrom #Studentcourseschedulegroup by departmentorder by Departmentgoselect department, courseid, COUNT(studentid) Studentcountfrom #Studentcourseschedulegroup by department,courseidorder by Department, Courseid[/code][u]1st Query Result:[/u]department Studentcount1 62 3[u]2nd Query Result[/u]department courseid Studentcount1 1 31 2 11 3 22 1 12 2 12 3 1In the first query the grouping is done only on Department, so it checks the no of students in each of the Department available in the table which is 1 and 2 in exampleWhen we add another group by column on courseid, now it looks for the each course available under each department and displays count of the student in that department and course.Sun, 24 Feb 2013 21:11:32 GMTdgowrijhttp://www.sqlservercentral.com/Forums/Topic1423210-392-1.aspxquery isselect col1, col2, col3.... from table Group BY Colm, ColnHere my question is :: while we take 2 or more colmuns in Group By..Actually how it worksFri, 22 Feb 2013 22:32:38 GMTr.dilliprasadhttp://www.sqlservercentral.com/Forums/Topic1423210-392-1.aspxthe title of your post [i] "In --> Group By with Multiple columns...> how it will responds " [/i] is not enough for us to go by;can you explain your question better? do you have a coded example that's not working as expected?Fri, 22 Feb 2013 12:40:03 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1423210-392-1.aspxcan any please help me...!Thanks & RegardsPrasad ReddyFri, 22 Feb 2013 12:11:58 GMTr.dilliprasad