Wednesday, 23 November 2011


The SQL MIN() aggregate function allows us to select the lowest (minimum) value for a certain column.

SQL MIN() Syntax

The SQL MIN() function syntax is very simple and it looks like this
SELECT MIN(column_name) FROM table_name

SQL MIN() Example

We have following "Table_1" name table:

S_NoS_NameTotalPercentage
1Jay50777.84
2Ajay48774.92
3Bhavesh46972.15
4Jaimin46371.23
5Dolar42565.38

Example Statement:
SQL> SELECT MIN(Total) AS SmallestTotal FROM Table_1;
Example Result will look like This:

Total
425








SQL GUIDE

0 comments:

Post a Comment

TrainingHUB. Powered by Blogger.

Total Pageviews

THE BEST QTP TRAINING INSTITUTE IN HYDERABAD

QTP Training in hyderabad

Sql Tutorial

Popular Posts

Our Facebook Page

TrainingHUB

Followers