I want to sort the table data based on the rank...
If ranks are equal, for example there are ten records of same rank, i want these ten records are in alphabetic order.... and the remaining will populate as usual based on rank....
Give me the query to implement it...
Do you mean free of charge? :rofl:
For this you need provide the table structure, I assume the following structure:
So your query should look like this:
FROM tblname AS t1
ORDER BY t1.rank ASC, t1.title ASC;
Thank you rajug.
It is working...