next → ← prev

SQL Server COUNT() Function

The SQL Server COUNT() function is used to return the count of an expression.

Syntax:

SELECT COUNT(aggregate_expression)
FROM tables
[WHERE conditions]; 

Example:

SELECT COUNT(id)
FROM [javatpoint].[dbo].[Employees];

Output:

SQL server count function 1

Let's take another table named "Employee2".

Example:

SELECT COUNT(*) AS "Number of Employees"
FROM Employee2
WHERE name = 'Rahul'; 

Output:

SQL server count function 2

This query is used when you have multiple employees of same name.

Next TopicSQL Server Comparison Operator

← prev next →

Help Others, Please Share

Learn Latest Tutorials

Kivy

Automation Anywhere Tutorial

A. Anywhere

Ext.js Tutorial

Ext.js

UiPath Tutorial

UiPath

Arduino tutorial

Arduino

Digital Electronics tutorial

Digital E.

Google Adwords tutorial

Adwords

MySQL

Python

Smartsheet

affiliate marketing

Affiliate M.

Software Testing Tutorial

Testing

Proc*C

social media marketing

SMM

Preparation

Aptitude

Logical Reasoning

Reasoning

Verbal A.

Interview

Company Interview Questions

Company

Trending Technologies

Artificial Intelligence Tutorial

AI

AWS

Selenium tutorial

Selenium

Cloud

Hadoop

ReactJS Tutorial

ReactJS

Data Science Tutorial

D. Science

Angular 7 Tutorial

Angular 7

Blockchain Tutorial

Blockchain

Git

Machine Learning Tutorial

ML

DevOps Tutorial

DevOps

B.Tech / MCA

DBMS

Data Structures tutorial

DS

DAA

Operating System tutorial

OS

Computer Network tutorial

C. Network

Compiler Design tutorial

Compiler D.

Computer Organization and Architecture

COA

Discrete Mathematics Tutorial

D. Math.

Ethical Hacking Tutorial

E. Hacking

Computer Graphics Tutorial

C. Graphics

Software Engineering Tutorial

Software E.

Web Tech.

Cyber Security tutorial

Cyber Sec.

Automata Tutorial

Automata

C

C++

Java

.Net Framework tutorial

.Net

Python

List of Programs

Programs

Control Systems tutorial

Control S.

Data Mining Tutorial

Data Mining

Javatpoint Services

JavaTpoint offers too many high quality services. Mail us on hr@javatpoint.com, to get more information about given services.

Website Designing
Website Development
Java Development
PHP Development
WordPress
Graphic Designing
Logo
Digital Marketing
On Page and Off Page SEO
PPC
Content Development
Corporate Training
Classroom and Online Training
Data Entry

Training For College Campus

JavaTpoint offers college campus training on Core Java, Advance Java, .Net, Android, Hadoop, PHP, Web Technology and Python. Please mail your requirement at hr@javatpoint.com.
Duration: 1 week to 2 week

^{Like/Subscribe us for latest updates or newsletter}

Subscribe to Get Email Alerts

YouTube