SQL SERVER | IN Condition

Mean and Mode in SQL Server

Last Updated : 28 Mar, 2018

Mean is the average of the given data set calculated by dividing the total sum by the number of values in data set. Example:

Input:  1, 2, 3, 4, 5 
Output: 3
Explanation: 
sum = 1 + 2 + 3 + 4 + 5 = 15
number of values = 5
mean = 15 / 5 = 3

Query to find mean in the table

SELECT Avg(Column_Name) 
FROM  Table_Name

Example: Creating Table:

Table Content:

Query to find Mean:

Mode of a data set is the value that appears most frequently in a series of data. Example:

Input:  1, 2, 2, 3, 4, 4, 4, 5, 5, 6
Output: 4
Explanation:
2 occurs 2 times, 5 occurs 2 times
4 occurs 3 times and rest other 
occurs 1 time
So, 4 occurs most frequently and 
is thus the output.

Query to find mode in the table

SELECT TOP 1 Column_Name
FROM   Table_name
GROUP  BY [Column_Name]
ORDER  BY COUNT(*) DESC

Example: Creating Table:

Table Content:

Query to find Mode:

SQL SERVER | IN Condition

S

Sam007

Improve

Article Tags :

Similar Reads

Order by in MS SQL Server

In this article, order by and terms related to order by will be discussed. Introduction - There are some instances where the tables are to be arranged in a chronological order. While the users use the select statement to retrieve rows, one cannot guarantee that the rows are arranged in an order. To

Joins in MS SQL Server

A database comprises tables and each table in case of RDBMS is called a relation. Let us consider a sample database named University and it has two tables named Student and Marks. If a user wants to transfer a certain set of rows, insert into select statement is used along with the query. But if a u

Introduction of MS SQL Server

Data is a collection of facts and figures and we have humungous data available to the users via the internet and other sources. To manipulate the data, Structured Query Language (SQL) in short has been introduced years ago. There are different versions of SQL available in the market provided by diff

SQL SERVER | IN Condition

IN condition is an alternative to multiple OR conditions in SELECT, INSERT, UPDATE, or DELETE statement. The IN operator allows multiple values to be tested against the expression and thus reduces the use of multiple OR conditions with each test value. Syntax: expression IN (value1, value2, .... val

LOG() Function in SQL Server

The LOG() function returns the logarithm of a specified number or the logarithm of the number to the specified base. Syntax : LOG(number, base) Parameter : LOG() function accepts two-parameters as mentioned above and described below. number - This parameter hold a number which is greater than 0. bas

CREATE SCHEMA in SQL Server

A schema is a collection of database objects like tables, triggers, stored procedures, etc. A schema is connected with a user which is known as the schema owner. The database may have one or more schema. To create a schema in SQL Server use the 'CREATE SCHEMA' Statement. SQL CREATE SCHEMACREATE SCHE

Alter login in SQL Server

Alter login statements can be used to changes the properties of a SQL Server login account. Syntax: ALTER LOGIN loginname; GO Enable a disabled login - Syntax : ALTER LOGIN loginname ENABLE; Example - ALTER LOGIN geeks ENABLE; Change password of a login Syntax : ALTER LOGIN geeks WITH PASSWORD = 'ne

Self Join and Cross Join in MS SQL Server

Prerequisite - Introduction of MS SQL Server 1. Self Join : Self-join allows us to join a table itself. It is useful when a user wants to compare the data (rows) within the same table. Syntax - select select_list from T t1 [Inner|Left] Join on T t2 on join_predicate. Here T refers to the table we us

Create login in SQL Server

Creating a login in SQL Server is a crucial step in securing your database and controlling access to it. A login is an account that allows a user to connect to the SQL Server instance and access the database. In this article, we will explore the process of creating a login in SQL Server and the vari

ISNUMERIC() Function in SQL Server

The ISNUMERIC() function in SQL Server is a critical tool for determining whether a given expression or value can be interpreted as a numeric type. This function is valuable for data validation and ensuring that values conform to numeric formats before performing calculations or other operations tha