how to use group by in two ield in mysql
Posted: Tue Mar 02, 2010 1:32 am
hai i have a table where student enter accordingly to their category and instituteid wise .
i want to see the student report to their category and instituteid wise how to make a query.........
i ran the follow query.........
SELECT Category, COUNT( StudentID ) AS Sum
FROM studentregdtb
GROUP BY Category
LIMIT 0 , 30
its gives only category wise student sum record.....but how to get in institutewise also..........
thanks
i want to see the student report to their category and instituteid wise how to make a query.........
i ran the follow query.........
SELECT Category, COUNT( StudentID ) AS Sum
FROM studentregdtb
GROUP BY Category
LIMIT 0 , 30
its gives only category wise student sum record.....but how to get in institutewise also..........
thanks