mysql FIRST() function
Translation results:
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() functionsyntax
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() functionexample
//查找 "OrderPrice" 列的第一个值 SELECT FIRST(OrderPrice) AS FirstOrderPrice FROM Orders;