SET ROWCOUNT in SQL Server

We can limit select results using SET ROWCOUNT.

SELECT * FROM Employee
It will display all result.

 

SET ROWCOUNT 2
SELECT * FROM Employee

Now it will display only two records.

That’s It.
Enjoy Learning.