English | 正體中文 | 简体中文

SQL limit


范例资料表 : Orders (以下范例皆用此表当作资料来源)
Keyid OrderNo CustomerName SalePrice Quantity OrderDate
1 20101213095 John 3500 10 2010-12-13
2 20100620135 Jimmy 2509 22 2010-06-20
3 20100620392 Vincent 7200 5 2010-06-20
4 20100530006 Tyler 9200 50 2010-05-30
5 20100515129 Alan 100 50 2010-05-29
6 20100509059 John 2000 15 2010-05-09
7 20100503088 Alan 2200 17 2010-05-03


Example
限制回传资料列的笔数

Sytax : SELECT * FROM table_name LIMIT number_of_rows
SQL
SELECT * FROM Orders LIMIT 3

会输出结果
Keyid OrderNo CustomerName SalePrice Quantity OrderDate
1 20101213095 John 3500 10 2010-12-13
2 20100620135 Jimmy 2509 22 2010-06-20
3 20100620392 Vincent 7200 5 2010-06-20


Example
限制回传的资料列笔数, 可指定起算位置

Sytax : SELECT * FROM table_name LIMIT start_position, number_of_rows
SQL
SELECT * FROM Orders LIMIT 2, 3

会输出结果
Keyid OrderNo CustomerName SalePrice Quantity OrderDate
3 20100620392 Vincent 7200 5 2010-06-20
4 20100530006 Tyler 9200 50 2010-05-30
5 20100515129 Alan 100 50 2010-05-29

© 2012 PureExample.com contact