Laravel:如何从数据库中获取最后 N 个条目

2021-12-26 00:00:00 database php laravel laravel-4 eloquent

我的数据库中有狗表，我想检索 N 个最新添加的狗.

I have table of dogs in my DB and I want to retrieve N latest added dogs.

我发现的唯一方法是这样的:

Only way that I found is something like this:

Dogs:all()->where(time, <=, another_time);

还有其他方法吗?例如像这样的 Dogs:latest(5);

Is there another way how to do it? For example something like this Dogs:latest(5);

非常感谢您的帮助:)

推荐答案

你可以试试这样的:

$dogs = Dogs::orderBy('id', 'desc')->take(5)->get();

使用 orderBy 和 Descending 顺序并取前 n 条记录.

Use orderBy with Descending order and take the first n numbers of records.

更新(因为添加了latest方法):

Update (Since the latest method has been added):

$dogs = Dogs::latest()->take(5)->get();

相关文章