mysql FIRST() function

UK[fɜ:st] US[fɜ:rst]

n. First, first; first class; number one,; [music] treble part

adv. first time; earliest , initially; rather; priority

adj. First-class; initial, earliest; basic, summary; high-pitched

num. First

plural: firsts

mysql FIRST() function syntax

Function:Returns the value of the first record in the specified field.

Syntax:SELECT FIRST(column_name) FROM table_name

Notes:You can use the ORDER BY statement to sort records.

mysql FIRST() function example

//查找 "OrderPrice" 列的第一个值 SELECT FIRST(OrderPrice) AS FirstOrderPrice FROM Orders;