venkat6134 — 2010-12-30T00:27:15-05:00 — #1
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...
system — 2010-12-30T00:30:24-05:00 — #2
Do you mean free of charge? :rofl:
raju_gautam — 2010-12-30T00:33:49-05:00 — #3
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;
venkat6134 — 2010-12-30T00:38:16-05:00 — #4
Thank you rajug.
It is working...