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'