- Learn T-SQL Querying
- Pedro Lopes Pam Lahoud
- 42字
- 2021-06-24 14:38:08
TOP
The TOP clause specifies that from the applicable rows, the results set only produces a predetermined number of rows, set in percentage or absolute number.
SELECT TOP 25 Name AS ProductName, LEFT(ProductNumber, 2) AS ProductCode, ISNULL(color, 'No Color') AS Color [...]