SQL - Structured Query Language (.sql)

SELECT TOP 10
	Although the SQL Server BOL claims that T-SQL doesn't support the TOP keyword, in fact it does—and this is a feature that's new to SQL Server 7.0. The TOP keyword also limits the number of rows returned but is used as part of the SELECT statement: http://gethelp.devx.com/techtips/thesqlpro/10min/10min0600.asp
	SELECT TOP 10 OrderID, CustomerID, EmployeeID, OrderDate FROM dbo.Orders WHERE EmployeeID = 5 ORDER BY OrderDate
Go Back