Top clause in SQL Server - Part 25
Subscribe to IT PORT : / itport28
SQL Server Tutorial in Tamil : • SQL Server Tutorial in Tamil
SQL Server Concepts in Tamil : • SQL Server Concepts in Tamil
SQL Server Analytic Functions in Tamil : • SQL Server Analytic Functions Tamil
SQL Server Tutorial : • SQL Server Tutorial
SQL Server Concepts : • SQL Server Concepts
SQL Server Analytic Functions : • SQL Server Analytic Functions
TOP is used to 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 conjunction with the ORDER BY clause, the result set is limited to the first N number of ordered rows; otherwise, it returns the first N number of rows in an undefined order. We can use this clause to specify the number of rows returned from a SELECT statement or affected by an INSERT, UPDATE, MERGE, or DELETE statement.