Home >> Oracle >> MIN in Oracle

MIN in Oracle

The MIN returns the lowest value of the selected column.

Syntax

SELECT MIN(columnname) FROM tablename WHERE condition; 

Example

SELECT MIN(price) AS lowestprice FROM products;

Post Your Comment

Next Questions
AVG
COUNT
SUM
What is key
What is Super Key
What is Candidate Key
What is Primary Key
What is Unique Key
What is Foreign Key
Function
Procedure
Cursor
Trigger
Before Trigger
After Trigger
DROP Trigger
DISABLE Trigger
ENABLE Trigger
Aggregate Functions
APPROX_COUNT_DISTINCT() Aggregate function
AVG() aggregate function
COLLECT() Aggregate Function
CORR() Aggregate Function
CORR_*
COUNT() aggregate function

Copyright ©2022 coderraj.com. All Rights Reserved.