0

I just stuck in one area and I am glad if you help me out of this problem.

My problem is similar to Get the rank of a user in a score table

But here is twist you already mentioned how to use WHERE Clause but if I want to join another table with this current table for add different condition in WHERE clause then how can we write INNER JOIN another_table_name ON first_table_name.table_column = another_table_name.table_column in following your conditions:

Where I can write this INNER JOIN another_table_name ON first_table_name.table_column = another_table_name.table_column and in where condition we can use then another_table_name.table_column='' so please suggest me how can we use in following query

SELECT id, name, score, FIND_IN_SET( score, (    
SELECT GROUP_CONCAT( score
ORDER BY score DESC ) 
FROM scores )
) AS rank
FROM scores
WHERE name =  'Assem' 
1
  • please add additional Information, by editing your question, also read please minimal reproducible example and gives us some example data and wanted output if that example data
    – nbk
    Oct 22 '20 at 14:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.