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 |
