TOP (Transact-SQL)
Limits the rows returned in a query result set to a specified number of rows or percentage of rows in SQL Server 2014. ... The TOP expression does not affect statements that may be executed because of a trigger. The inserted and deleted tables in the trig...