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
Popular Posts
-
Java Server Pages JavaServer Pages (JSP) technology is the Java platform technology for delivering dynamic content to web clients in a por...
-
In previous chapters, you learned to how to connect to SQL Server 2005 using management studio. In this chapter, you will learn how to creat... -
Defined data types (typedef) C++ allows the definition of our own types based on other existing data types. We can do this using the keyword... -
DIFFERENCE BETWEEN STRUCT AND UNION: In structures,each member has its own storage location,whereas all memebers of a union use the same loc...
-
Additional Form's Properties The Form has many of the Command Button's properties (MousePointer, BackColor, Visible and more). He al... -
# When the user submits form, his information is sent to the corresponding servlet file because we've set the ACTION attribute to point ...
-
Steps to follow: 1. Write Relation.java as shown in Code-11.5.a below. Please note that the Relation is an interface. (You are welcome to d...
No comments:
Post a Comment