How would I retrieve the second result with query builder?

251
June 29, 2017, at 05:30 AM

I am trying to retrieve the second result of this query (which works successfully):

$assist_stats = App\Stat::whereRaw('assists = (select max(`assists`) from stats)')->get()->first();

With this modified code:

$assist_stats2 = App\Stat::whereRaw('assists = (select max(`assists`) from stats)')->get([1]);

But I get this error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column '1' in 'field list' (SQL: select `1` from `stats` where assists = (select max(`assists`) from stats))

How would I retrieve the second result from the query?

Rent Charter Buses Company
READ ALSO
MySQL Master/Slave Replication

MySQL Master/Slave Replication

I was trying to find some answers about this, and I couldnt find any possible post with similar/same problemPlease excuse me If I somehow missed it

320
How to create html table from mysql “GET” request in Flask framework

How to create html table from mysql “GET” request in Flask framework

I have set up a Flask app that is connected to my mysql databaseIt can POST request fine and also GET

313
MySQL query to search for items with parent items tag

MySQL query to search for items with parent items tag

So I followed what they did here: MySQL query to search for items with certain tags

240
Query Optimization With Multiple Tables and Big Data

Query Optimization With Multiple Tables and Big Data

I am doing a project for my Master Degree where I have a 500GB of MySQL databaseMy project has to do with StackOverflow thus why it is so big

391