What is alternative of TOP keyword in SQL Server?

1.	What is alternative of TOP keyword in SQL Server?
Answer» What is alternative of TOP keyword in SQL SERVER? We can USE ROWCOUNT as alternate option for TOP keyword. But syntax is DIFFERENT from top keyword in SQL Server. Below is syntax for ROWCOUNT:- Set rowcount 3 Select * from table_name order by id desc Set rowcount 0

Discussion