sql初級教程:select top 使用教程

sql初級教程:select top 使用教程

好了下面我們來看看在select top 的語法吧.

如mssql :select top 10 from table_name

在mysql:select * from table_name limit 0,10

SELECT TOP number|percent column_name(s)
FROM table_name

下面我們來看個實例教程.

_Id LastName FirstName Address City 1 Hansen Ola Timoteivn 10 Sandnes 2 Svendson Tove Borgvn 23 Sandnes 3 Pettersen Kari Storgt 20 Stavanger 4 Nilsen Tom Vingvn 23 Stavanger

mssql 或access SELECT TOP 2 * FROM Persons

mysql select * from persons limit 0,2

他們輸出的結果都一樣如下表.

Id LastName FirstName Address City 1 Hansen Ola Timoteivn 10 Sandnes 2 Svendson Tove Borgvn 23 Sandnes