SQL Queries||How many ways to skip TOP 'N' Rows from the table?

1. select * from emp Order by id Offset 6 rows

2. select * from
(select *, row_number() Over (order by id) rn from emp) Result
where rn gt =7

3. select * from emp where id not in(
select TOP 6 id from emp group by id)

4. select * from emp
EXCEPT
select TOP 6 * from emp order by id

5.select * from emp e1 WHERE
(select COUNT(*) from emp e2 WHERE e2.id lt =e1.id) gt 6

Видео SQL Queries||How many ways to skip TOP 'N' Rows from the table? канала SQLtoSSIStoPowerBI