摘要:
注:并非所有的数据库系统都支持 TOP 子句。Persons 表:IdLastNameFirstNameAddressCity1AdamsJohnOxford StreetLondon2BushGeorgeFifth AvenueNew York3CarterThomasChangan StreetBeijing4ObamaBarackPennsylvania AvenueWashingtonSQL Server 语法:SELECT TOP number|percent 列 FROM 表例:如果我们希望从上面的表中选取头两条记录。语句如下:SELECT TOP 2 * FROM Persons 阅读全文