MAX Function In SQL Server 2008

In this article I am going to explain MAX Function in SQL.
  • 2135

Introduction

 The MAX() function is the one that  returns the largest value of the column which is selected.

Syntax

SELECT MAX(column_name) FROM table_name

Example

Suppose we create table named "pupils", then:

MAX_function-in-sql.jpg


Result

 MAX1_function-in-sql.jpg


Categories

More Articles

© 2019 DotNetHeaven. All rights reserved.