How to retrieve data from a table from the same column but having different values in laravel 4
<p>i have a table called (tickets) with (movie_id)column and (amount)column,
how can i retrieve a movie with the highest amount?thank you</p>

<pre><code> $movies = DB::table('tickets')-&gt;where('movie_id',$id)-&gt;having('amount', '&gt;', 1000)-&gt;get();
</code></pre>