How to form a query for this?

Databases
1

Hi all,
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…

Thanking you…

2

Do you mean free of charge? :rofl:

3

For this you need provide the table structure, I assume the following structure:


id
title
rank

So your query should look like this:


SELECT t1.*
FROM tblname AS t1
ORDER BY t1.rank ASC, t1.title ASC;
4

Thank you rajug.
It is working…