SQL Function: MIN()

Definition:

Return the lowest value of records.

---

Command Syntax:

MIN(field_name)

---

Command Example:

Table STUDENT

SID	SNAME	CLASS	CNO	MARK
010122	Chris Wong	1A	5	19.4
010141	Gabe Lin	1C	6	35.6
010142	Nico Lin	1C	7	34.8
010133	Amy Chan	2D	12	-97.5

Input:

SELECT * FROM STUDENT WHERE MARK IN
(SELECT MIN(MARK) FROM STUDENT);

Output:

SID	SNAME	CLASS	CNO	MARK
010133	Amy Chan	2D	12	-97.5

---

‘...’By secondary 6 student