SQL COUNT Command

Computer Programming Forums : Questions and Answers, Articles, Tutorials, and Code Snippets

Switch to full style
Include SQL commands
Post a reply
DrRakha
  • DrRakha
  • Posts: 2715
  • Joined: Tue Mar 27, 2007 10:55 pm
  • Location: Earth
  • Website

SQL COUNT Command

Sun Jul 15, 2012 9:41 pm

Use the COUNT command to count number of records in a table.

Code:

SELECT count( * ) as total_record FROM Department


you can also use where clause :

Code:

SELECT count( * ) as total_record  FROM `Department` WHERE numOfStudents= '50'
 




Post a reply
  Related Posts  to : SQL COUNT Command
 Unique Row Count Across Columns     -  
 count elements in a vector     -  
 String char count     -  
 Return words count in a string     -  
 count the number of files in directory & its sub directories     -  
 SELECT-Group by and Order by,Having Clause,count(),Joins     -  
 BETWEEN SQL COMMAND     -  
 JVM does not recognize MQ command.     -  
 Calling the man Command     -  
 Average SQL command     -  
Switch to full style

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


Powered by phpBB © phpBB Group.


Codemiles.com