SQL SERVER||How to get TOP 10 rows of table without using TOP clause?

Two ways to get First 'N' Rows from a table without using TOP clause in SQL...

1. SET ROWCOUNT 20
SELECT * FROM Person_Data
SET ROWCOUNT 0

2. ROWNUM
SELECT * FROM
(SELECT ROW_NUMBER() OVER (ORDER BY id)AS ROWNUM,
* FROM Person_Data) TEMP
WHERE ROWNUM is less than 11

Видео SQL SERVER||How to get TOP 10 rows of table without using TOP clause? канала SQLtoSSIStoPowerBI