var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
i have a table with country names
it is populated with:
i want a query which gives the foll output
(i.e) USA and UK must be on the top 2 rows
while the rest of the countries should come below these 2 and sorted in the ascending order.
if it is possible with any other query also it is ok
Last edited by bhargavi; 07-12-04 at 05:16.
My simple way would be to add a field and then use it to sort the result. e.g.
UK 01 UK
USA 02 USA
Africa 03 Africa
Alternately have ONLY the numeric prefix in your table but show only from postion 4 in the string. I'm sure other variations exist.
You could have a seperate table having only USA and UK outer joined to the main one and sort by the null or otherwise of the mini table