How to use percentage in a Laravel query

Question

The following query will result in 100 rows :

$qtop = Quest::where('ttype',$id)      
                     ->where('country', $ucountry ) 
                     ->where('score', '>' , 240 ) 
                    ->orderby('score', 'desc')  
                    // ->take(25)
                    ->get();

Instead of using ->take(25) how can I take 25% of the total rows ?

Does this answer your question? [Mysql Select only percentage of rows](https://stackoverflow.com/questions/22763342/mysql-select-only-percentage-of-rows) — piotr, Jan 07 '20 at 22:49

Mohamed23gharbi · Accepted Answer · 2020-01-09T10:15:10.500

1

in plain sql server syntax you can use TOP 25 PERCENT

select TOP 25 PERCENT * from table

For plain mysql you need to use nested queries @see Convert SQL Server query to MySQL :

SELECT *
FROM
(
    SELECT table.*, @counter := @counter +1 counter
    FROM (select @counter:=0) initvar, table
    ORDER BY score
) X
WHERE X.counter <= (25/100 * @counter)
ORDER BY score

edited Jan 09 '20 at 10:15

answered Jan 07 '20 at 22:29

Mohamed23gharbi

1,710
23
28

1

I think this is SQL server syntax not Mysql. – Abdallah Sakre Jan 07 '20 at 22:39
There's really no such thing as "plain SQL". There's various SQL standards, and a whole bunch of dialects, all of which tend to contradict the others. – tadman Jan 07 '20 at 23:27

score 0 · Answer 2 · answered Jan 08 '20 at 07:28

0

Just check the documentation;

$users = DB::table('users')->skip(10)->take(5)->get();

https://laravel.com/docs/6.x/queries#ordering-grouping-limit-and-offset

answered Jan 08 '20 at 07:28

Anıl Şenocak

117
7

How to use percentage in a Laravel query

2 Answers2