Select last record in the table

Question

How to select last record (that is having MAX(id)) from the table?
Next statement works OK, but selects the first record:

$statistics = SystemStatisticsHistory::findOne(1); 

Solution

To get the model with max id you can apply reverse order and limit to one.

SystemStatisticsHistory::find()->orderBy(['id' => SORT_DESC])->one();

Another option is to use subselect with max like so:

SystemStatisticsHistory::find()
    ->where(['id' => SystemStatisticsHistory::find()->max('id')])
    ->one();

There are some nuances using last option, check this question.

You can check the documentation for max() here.

I personally prefer using first variation.

To get the first record, just change the order direction to SORT_ASC in first query and max() to min() in second query.

P.S. Hardcoded id is a bad practice.

Comments

[arogachev]

Glad to help. Mark the answer as accepted in this case.