SQL Evi  
Tuesday, September 07, 2010
 
Aga Download, Aga Msn, Aga Oyun, Garavel, ASP Rehberi, ASP Indir, Bekir Topuz, Erinç Kuzu, Kartuş Marketi, SQL Evi - House
 
SQL Count  
Home › SQL Count  
The SQL COUNT aggregate function is used to count the number of rows in a database table.  

The SQL COUNT aggregate function is used to count the number of rows in a database table.

The SQL COUNT syntax is simple and looks like this:


SELECT COUNT(Column1)
FROM Table1

If we want to count the number of customers in our Customers table, we will use the following SQL COUNT statement:


SELECT COUNT(LastName) AS NumberOfCustomers
FROM Customers

The result of this SQL COUNT query will be:

NumberOfCustomers
4

 
 
 
 
Home › SQL Count Top  
 
Hosted By Speed Layer
© 2009 SQL Evi