Mention what is TOP in TSQL?

Technology CommunityCategory: T-SQLMention what is TOP in TSQL?
VietMX Staff asked 3 years ago

TOP limits the rows returned in a query result set to a specified number of rows or percentage of rows in SQL Server. When TOP is used in combination with the ORDER BY clause, the result set is limited to the first N number of ordered rows. Otherwise, it retrieves the first N number of rows in an undefined order.