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;

Popular Recommendations

Home

Videos

Q&A