Is there a way to get some selected data first & amp; rest data in ascending order via SQL Query

Suppose I have country data in unmannered way (not in sequence) in table tbl. Now I want to show Country 'United States','Canada' & 'India' first & rest of the country shown in ascending order.

Country

India
China
Brazil
Azerbaijan
Bahamas
United State
Denmark
Canada

Now I want this data as :

Country

United State        // US,Canada,India should be First 3.
Canada
India
Azerbaijan         // After rest country comes in ascending Order.
Bahamas
Brazil
China
Denmark

Any suggestion really appreciate.

SELECT Country FROM tbl
ORDER BY CASE
  WHEN Country='United State' THEN 0
  WHEN Country='Canada' THEN 1
  WHEN Country='India' THEN 2
  ELSE 3
END, Country;

Is there a way to get some kind of iPhone SIM card ID by program?

Is there a LEGAL or PUBLIC-API way to obtain some sort of SIM card identifier programmatically, the only thing so far i found is that there is a NSNotification that occurs when SIM card is changed while app is in runtime, but that is not enough for m

Is there a way to get internal php data?

I know there are PHP debugging tools available, but I'm curious about doing something like this myself. Is there a way to obtain the data that is being processed by PHP for debugging purposes? For example, without having to change the code of my PHP

Is there a way to get the HTML code of a JADE model before sending it via the answer

What I usually do is: res.render('myJadeTemplate'); but I want to add another transformation to the html before attaching it to the response. How can I get the rendered HTML then modify it and send it over via res.send()If you are using Express3. The

VB.NET - Is there a way to get the name of a column in an MS Access table for a query used on any table?

I am trying to get the name of a single column in a table and use that in a query for sorting. As an example of what I'm trying to achieve would be as follow: TableA has 2 columns: "FirstName" and "LastName". I make a query to SELECT *

How to get the first row of the table in Sqlite via Sql Query

I need to fetch the first/top row of a table in a Sqlite database. But my program throws an SQLException "Sqlite Syntax Error: Syntax error near '1' " for the query that I am using: SELECT TOP 1 * FROM SAMPLE_TABLE That I guess is a syntax parti

Is there a way to get more accurate MySQL error messages?

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near [random snippet of query code] I am very rarely able to deduce something of value from MySQL errors like that one, i

Is there a way to get all Twitter tweets for a specified user?

I wanted to write a function for grabbing all tweets for specified user, but it returns only 20 most recent. I came up with something like that: function getTweets($user) { $page = file_get_contents("http://twitter.com/{$user}"); $from = strpos(

Is there a way to get the offset of the selected text in an input box in IE?

In Firefox, you can simply call: myInputTextField.selectionStart or myInputTextField.selectionEnd to get the first and last indices of the selected text in the input box. In IE, I know that you can call document.selection.createRange() to fiddle with

Is there a way to get a hierarchical index on the node where the cursor is located?

In the XML document I want to find the node that the cursor is in. I don't think Ace Editor can do this. But I think maybe it keeps track by using indexes system. What do I mean? Well, in XML there is a hierarchical structure of leaves and branches o

Is there a way to get the DateTime value from the timestamp column?

I need a select from table which does not have column that tells when row was inserted, only timestamp column (values like: 0x0000000000530278). Some data was imported to the table yesterday and now I need to find out what exactly was imported :( Is

Is there a way to get a full iOS crash log when debugging?

Is there any way to get a full iOS crash log when debugging? For example... I have my phone plugged in, code open, run the app in Debug mode, and the app crashes on a specific line of code. Is there any way to get the crash log from that? Or do I act

Is there a way to get a single INT key for items in HashMap & lt; String, String & gt; ?

Wondering is there a way to get unique integer key for each elements in HashMap. I have considered hashCode() but realized unique key is not guaranteed. Can write a separate program using various algorithm but looking for some light weight built in s

Is there a way to get Selenium 2.23 on Ubuntu 11.10?

I was using Firefox 12 with Selenium::WebDriver (ver 2.22) and everything was working fine. Then I, stupidly, upgraded to Firefox 13 via the Ubuntu weekly updates. Selenium (2.22) could not control FF 13 so I went out and got Selenium 2.23. Then I st

Is there a way to get a client hostname by the cherrypy server?

I have a cherrypy server on a machine, and i want to get the client identifier from the request. Now i can get the client IP by cherrypy.request.remote.ip, but if the client user use a proxy then the IP address will be the proxy address that i don't

Related Articles