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;