我想记录最后的记录。 [英] I want to get records last records.

问题描述

我的桌子上有100条记录。我只想要91到80个记录。



我每次都会获得最后10个记录。我的意思是下次我的表中有200条记录，我想要191到180之间的记录。就像这样。



请帮助我，



谢谢。

Hi,

I have 100 records from my table. I want only between 91 to 80 records.

Every time I will get last but 10 records. I mean next time 200 records in my table I want records between 191 to 180. like this.

please help me,

Thank you.

推荐答案

嗨...

见这个！

Hi...
See this one!

>>for last records from table only.
SELECT *
FROM table_name
ORDER BY id DESC
LIMIT 1

>>for between records from table only.
SELECT * FROM test LIMIT 10, 100
//It will display records from 101-110

谢谢你。

Thank u.

试试这个.. :)

try this.. :)

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

这篇关于我想记录最后的记录。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！