mysql TOP statement
Translation results：
英[tɒp] 美[tɑ:p]
n. Top, top; (box) cover, (book pages, etc.) upper column; chief; top
adj. Highest of; top; first-class; the largest
vt. form the top; reach the top of...; be at the forefront of...; lead
vi. Summary; transcend; tower; end
Third person singular: tops Plural: tops Present participle: topping Past tense: topped Past participle: topped
mysql TOP statementsyntax
Function: is used to specify the number of records to be returned.
Syntax: SELECT column_name(s) FROM table_name LIMIT number
Description: For large tables with thousands of records, TOP clauses are very useful.
Note: Not all database systems support the TOP clause.
mysql TOP statementexample
//查询"persons"表中头5条数据 SELECT *FROM Persons LIMIT 5; //从 "Persons" 表中选取 50% 的记录 SELECT TOP 50 PERCENT * FROM Persons;