OFFSET -FETCH option is filltering option that like ,top you can use fillter the data based on number of rows. Difference between TOP and OFFSET- FETCH Is OFFSET-FETCH it skippes the rows.In TOP Option it will not skip. The OFFSET-FETCH option is rigth after the order by . The order by is required when OFFSET-FETCH option includes. The OFFSET-FETCH option intorduced in SQL-SERVER 2012. We can use OFFSET-FECTH option implement pagenation. --create Employee table create table Employee ( EmpId int identity ( 1 , 1 ) primary key , FirstName varchar ( 100 ), LastName varchar ( 100 ), JoinDate ...