SQL GROUP BY Command

GROUP BY command will create a group by a specific column and will count the records in each group as follows :

Code:

SELECT count(*) as total_records, class FROM 'Department' group by type

You can also add where clause to the this type of queries as follows :

Code:

SELECT count( * ) AS total_records, class FROM 'Department' WHERE NumOfStudents>100 GROUP BY type

_________________
M. S. Rakha, Ph.D.
Queen's University
Canada

Author: DrRakha
Mastermind

Posts: 2715
Have thanks: 74 time

Page 1 of 1

[ 1 post ]

Related Posts to : SQL GROUP BY Command
Cannot Delete Computer group -
SELECT-Group by and Order by,Having Clause,count(),Joins -
The New Indian Express Group Bangalore : Electrical Engineer -
BETWEEN SQL COMMAND -
Calling the man Command -
SQL COUNT Command -
SQL LOCATE command -
SQL LIKE query Command -
SQL ALTER Command -
SQL DISTINCT Command -

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com