The COUNT() returns the number of column or rows that matches a specified criteria.
Syntax:-
The COUNT(column_name) returns the number of values of the specified column:-

SELECT COUNT(column_name) FROM table_name;

OR

SELECT COUNT(*) FROM table_name;

OR

SELECT COUNT(DISTINCT column_name) FROM table_name;
Example:-
The subsequent SQL counts the number of Visit from “VisitorID”=17 from the “Visitors” table:-

SELECT COUNT(VisitorID) AS VisitFromVisitorsID17 FROM Visitors WHERE VisitorID=7;

OR

SELECT COUNT(*) AS NumberOfVisits FROM Visitors;

Categories: SQL Function

0 thoughts on “SQL Count()”

Leave a Reply

Related Article

SQL Function

SQL Avg()

The AVG() returns the average value of a numeric column. Syntax:- SELECT AVG(column_name) FROM table_name; Example:- The subsequent SQL gets the average value of the “Price” column from the “Hosting” table:- SELECT AVG(Price) AS PriceAverage Read more…

SQL Function

SQL First()

The FIRST() function returns the first value of the selected column. Syntax:- SELECT FIRST(column_name) FROM table_name; OR SELECT column_name FROM table_name ORDER BY column_name ASC LIMIT 1; Example:- The subsequent SQL selects the first value Read more…

SQL Function

SQL Last()

The LAST() returns the last value of the selected column. Syntax:- SELECT LAST(column_name) FROM table_name; OR SELECT column_name FROM table_name ORDER BY column_name DESC LIMIT 1; Example:- The subsequent SQL selects the last value of Read more…