Sql Max() frunction is an aggregate function that returns the highest value of an expression, to get the maximum value in your statement use this function.
Example:1
Select MAX(sal)
from emp;
Example:2
Select Max(sales_order_date)
from sales_order
Labels
- AVG() Function (1)
- Aggregate Functions (1)
- Candidate Key (1)
- Composite and Compound Keys (1)
- EXISTS (1)
- FIRST() Function (1)
- Group By Statement (1)
- Having Clause (1)
- INSERT (1)
- LIKE (1)
- SELECT AS CLAUSE (1)
- SQL Distinct Unique Records (1)
- SQL IN (1)
- SQL Joins (1)
- SQL Last() Function (1)
- SQL NULL Conditional (1)
- SQL Not Exists (1)
- SQLComparison Operators (1)
- Sql Max() Function (1)
- Sql Min() Function (1)
- Sql SUM() Function (1)
- WHERE (1)
Blog Archive
-
▼
2010
(73)
-
▼
April
(21)
- Monthly Count at Column Level
- SQL SUM() Function
- SQL Min() Function
- SQL Max() Function
- SQL Last() Function
- SQL Not Exists
- FIRST() Function
- COUNT() function
- The AVG() Function
- SQL Aggregate Functions
- Group By Statement
- HAVING Clause
- SQL Joins
- Full Text Search
- CONTAINS Predicate
- WHERE Clause
- EXISTS
- Like Operator
- UNION/INTERSECT CLAUSES
- INSERT Statement Syntax
- SELECT - SQL Command
-
▼
April
(21)
Tuesday, April 20, 2010
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment