Q:

MySQL | PARTITION BY Clause - Not working on XAMP

There is an article published by Geeks for Geeks on the MySQL Partition clause at https://www.geeksforgeeks.org/mysql-partition-by-clause/. 
But the same query not working after creating the same table in my XAAMP MySQL.  It's giving me the syntax error to use near '(partition by challenge_id....)
Can anyone help? 

A:

Maybe the issue is your mysql version.  the partition by is in version 5.7 and the dense_rank() can be use only in version 8. 
try to use mysql v8 and it will be work fine
DB_Fiddle

