23 January 2014

SELECT command with MIN () function

MIN () function returns the minimum value of column of table.

Syntax:

SELECT MAX ([SPECIFIED_COLUMN_NAME]) FROM <TABLE_NAME>

Example:

--- CALCULATE MIN VALUE OF COLUMN USING MIN FUNCTION
SELECT MIN(SALARY) FROM STUDENT_MARKS

No comments:

Post a Comment