SQL Query for desired output -

i have table contains countries:

countries ============ australia south africa bangladesh new zeland sri lanka england ... 

desired out put is

country =========== india sri lanka followed other countries in `asc` or `desc` 

you can use case:

sqlfiddledemo

select * countries order   case name      when 'india' 0      when 'sri lanka' 1      else 10   end asc,   name asc -- desc