Top « Query « SQL Server / T-SQL Tutorial

1.15.Top
	1.15.1.	TOP n Clause
	1.15.2.	TOP n Query with ORDER BY
	1.15.3.	Top Clause with the UPDATE statement.
	1.15.4.	Use TOP n clause with the DELETE statement.
	1.15.5.	A SELECT statement with a TOP clause
	1.15.6.	A SELECT statement with a TOP clause and the PERCENT keyword
	1.15.7.	A SELECT statement with a TOP clause and the WITH TIES keyword
	1.15.8.	A query that uses a derived table to retrieve the top 5 Bankers by average Billing total
	1.15.9.	Define variable for query top percent

	1.15.10.	Declare variable and use it in 'TOP PERCENT'