Top 100 Percent In Sql. Sql 2000 v. Select top 10 percent employeeid lastname firstname from employees where lastname anderson order by employeeid.
Tables dont have a natural order and neither do views. The select top clause is used to specify the number of records to return. In general the top and order by construction are used together.
Select top10 percent contactid lastname firstname from contacts where lastname anderson order by contactid.
Let us see a quick script for the same. Top clause contains something other than 100 percent for example. It does not count any null values. The sql select top clause.