SQL GROUP BY Command

Switch to full style

Post a reply

DrRakha

DrRakha
Posts: 2715
Joined: Tue Mar 27, 2007 10:55 pm
Location: Earth
Website

Sun Jul 15, 2012 11:02 pm

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

Post a reply

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 -
Average SQL command -
JVM does not recognize MQ command. -
Calling the man Command -
SQL COUNT Command -
SQL LOCATE command -
SQL LIKE query Command -

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