查询与Mysql记录有关，并且只提取其中的一些

Question

I have 10 Records in my database and I want 5 records from it.

Like 1,2,3,4,5,6,7,8,9,10 and I want records from 3,4,5,6,7,8

Records are dynamic and can change very frequently.

 Select * 
 From file 
 Where file_status = 1 
 Order By file_date DESC 
 limit 5

This Won't work, just because this will fetch only last five records..

Answer 1

select * from file where file_status = 1 order by file_date DESC limit 2,6

will get data as your examp