When you need to find the minimum value of a column, you can use the SQL MIN function. The result will return a single record with the lowest value of the specified column.

The syntax for the MIN function is:

SELECT MIN("column_name")
FROM "table_name"

Table: Student

For example if want to find the minimum value of a course fees we would use the following statement:

SELECT MIN(CourseFees)
FROM Student

RESULT:

Minimum Course Fee

1000.00

• Add New
• Search

Comments (0)

Write comment

Your Contact Details:

Name:

Email: do not notifynotify

Website:

Comment:

Title:

UBBCode:         -color-aquablackbluefuchsiagraygreenlimemaroonnavyolivepurpleredsilvertealwhiteyellow -size-tinysmallmediumlargehuge

Message:

Security

Please input the anti-spam code that you can read in the image.

!joomlacomment 4.0 Copyright (C) 2009 Compojoom.com . All rights reserved."