I want to get records last records.

with samp as(

  select *,ROW_NUMBER() over (order by id)AS RowNo from tableName
  )
  select * from samp where RowNo >((select max(RowNo) from samp)-21) and  RowNo <((select max(RowNo) from samp)-8)

declare @maxRowIndex int

set @maxRowIndex =(  select top 1 ROW_NUMBER() OVER (ORDER BY JobID desc) AS RowNum
     FROM Job order by RowNum desc)
  select @maxRowIndex


SELECT *
FROM (
     SELECT *, ROW_NUMBER() OVER (ORDER BY JobID desc) AS RowNum
     FROM Job
     ) AS MyDerivedTable
     where MyDerivedTable.RowNum<=(@maxRowIndex-9) and MyDerivedTable.RowNum>=(@maxRowIndex-20)
 order by JobID asc

SELECT *FROM tbl_name
ORDER BY id DESC OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY;

SELECT * FROM
    (SELECT ROW_NUMBER()
        OVER (ORDER BY Your_Order_Column) AS Row,
       Col1, Col2 
    FROM TableName) AS T1
WHERE Row > 80

select top 10 * from Job order by jobid desc 

declare @startvalue int=91;
declare @endvalue int=80;
select top (@startvalue) * from tblFiles
except
select top (@endvalue) * from tblFiles

SELECT * FROM table WHERE date = (SELECT MAX(date) FROM table) LIMIT 1;

select top 10 * from (select top 20 * from [table ] order by column1 desc) as a order by column1 asc

<pre lang="SQL">

select top 10 * from tblName order by col1 desc


here col1 is the table colum by which you ordering your table.
</pre>