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'