How to remove the duplicate data from the ranking query results?

there is a user ranking table, which needs to be sorted by score and output. If there is a duplicate user, take the highest score of that user
now I write

DB::select("SELECT nickname, id, fraction, FIND_IN_SET( fraction, (    
                    SELECT GROUP_CONCAT( fraction
                    ORDER BY fraction DESC ) 
                    FROM fan_rankings WHERE test_id=$test_id)
                    ) AS rank
                    FROM fan_rankings
                    WHERE test_id = $test_id AND user_id = $user->id ORDER BY fraction DESC");

I added a GROUP BY (user_id before ORDER BY), but if there is an error, please tell me what to do
and how to write it in ORM. I feel it"s a bit complicated to write in native
my own version of laravel5.4
Please don"t hesitate to give me your advice

Mysql laravel php

Jun.24,2021

DB::select("SELECT distinct nickname, id, fraction, FIND_IN_SET( fraction, (    
                    SELECT GROUP_CONCAT( fraction
                    ORDER BY fraction DESC ) 
                    FROM fan_rankings WHERE test_id=$test_id)
                    ) AS rank
                    FROM fan_rankings
                    WHERE test_id = $test_id AND user_id = $user->id ORDER BY fraction DESC");

try adding a distinct

do it with redis! Mysql is not suitable for real-time ranking at all

FanRanking::query()->groupBy('user_id')->orderByDesc('fraction')->limit(100)->get(['user_id', \DB::raw('max(fraction) as fraction')])

the answer from a big guy in the laravel community looks concise and useful!

Previous: What if the background request.form of the blob object cannot be obtained by using formData?

Next: Mini Program, the developer of wepy plus minUI, encountered a problem.

On the problem of laravel5.4 form validation in different scenarios
just started to use the laravel framework development, or rookies ~ a lot of do not quite understand, at present to do a function, customized a form verification class file ~ ~ for example, I am now a member module, my member controller can have many way...

Mysql laravel php

Mar.01,2021
Bootstrap-treeview onNodeExpanded gets the current height, but each time it gets the height before deployment.
1.bootstrap-treeview onNodeExpanded gets the current height, but each time it gets the height before deployment. I want to get the current height after deployment 2. 3.console.log (event) sees that the clientHeight inside is 1049; but console.log...

Html5 mysql laravel php javascript

Mar.04,2021
Php in laravel, what is wrong with my mysql statement?
$res = DB::connection( mysql_business )->table( t_activity ) ->select( SELECT app_id,title ,created_at,id FROM t_activity WHERE created_at > ? ORDER BY created_at DESC , [ 2018-04-01 20:11:12 ...

Mysql laravel php

Mar.04,2021
Spatie/laravel-backup backup database
can the 1.spatie laravel-backup backup database specify which tables are backed up, which tables do not need to be backed up, and how to configure them? 2. 3. At present, it specifies the database type, and I don t think these are specified in the ...

Windows github mysql laravel php

Mar.14,2021
When a cloud project is deployed, how to access the user's own database?
has such an idea: the front-end and back-end codes of the project are deployed in a CVM of your own. your own CVM stores basic database data; users choose my server to store data or the server they buy to store data. I don t know if there is ...

Load-balancing mysql laravel php

Mar.24,2021
Mysql data loss
found occasional data loss in mysql. This time I lost a record in the order table. I used laravel framework . generate order retention user submit order-> Table 1 generate order-> user payment-> payment callback-> Table 1 status modification, insert...

Mysql laravel php

Apr.05,2022

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e57be7-447ac.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e57be7-447ac.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?