Total members 11864 |It is currently Thu Dec 09, 2021 4:54 am Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka






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 `DepartmentWHERE numOfStudents'50'
 




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


Author:
Mastermind
User avatar Posts: 2715
Have thanks: 74 time
Post new topic Reply to topic  [ 1 post ] 

  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     -  










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