I have a table in sql which has 3 column
id , name and value .
I want to show list of column order by priority in desc order
like "select * from priority where priority>1 order by priority desc "
but when priority having same value then set it to order by rand() with same value of priority then show list.
I have attached snap of table