Laravel Query Builder where max id

Question

How do I accomplish this in Laravel 4 1 Query Builder   select   from orders where id    select max  id   from orders    I tried this  working but can t get the eloquent feature    DB  select DB  raw  select   from orders where id    select max  id   from orders        Any idea to make it better

User · Answer

For objects you can nest the queries   DB  table  orders  - gt find DB  table  orders  - gt max  id       So the inside query looks up the max id in the table and then passes that to the find  which gets you back the object

User · Answer

For Laravel  5  Orders  max  id      I used it is short and best

User · Answer

Just like the docs say  DB  table  orders  - gt max  id

User · Answer

No need to use sub query  just Try this Its working fine       DB  table  orders  - gt orderBy  id    desc  - gt first

User · Answer

You should be able to perform a select on the orders table  using a raw WHERE to find the max id  in a subquery  like this     DB  table  orders  - gt where  id    DB  raw   select max  id   from orders    - gt get      If you want to use Eloquent  for example  so you can convert your response to an object  you will want to use whereRaw  because some functions such as toJSON or toArray will not work without using Eloquent models     order   Order  whereRaw  id    select max  id   from orders   - gt get      That  of course  requires that you have a model that extends Eloquent     class Order extends Eloquent      As mentioned in the comments  you don t need to use whereRaw  you can do the entire query using the query builder without raw SQL       Using the Query Builder   DB  table  orders  - gt find  DB  table  orders  - gt max  id          Using Eloquent   order   Order  find  DB  table  orders  - gt max  id        Note that if the id field is not unique  you will only get one row back - this is because find   will only return the first result from the SQL server

[php] Laravel Query Builder where max id

Examples related to php

Examples related to laravel

Examples related to query-builder