How to start displaying from the table starting from 3 by id from the end?

Question

MySQL

I know there is one($id) method. But if you don't know the id, but you just need to display starting from 3 in the id count from the end?

Answer 1

Use LIMIT 0, 3 and ORDER by id desc.

Answer 2

MyModel::find()->orderBy('id DESC')->limit(3)->all();

sort by id in reverse order, select 3 records.

Answer 3

MyModel::find()->orderBy('id DESC')->limit(10)->offset(3)->all();