need to get sql query

Question

5.00/5 (1 vote)

See more:

SQL-Server-2008

Hi Friends,

I have a Currency table with records as follows :

ID Name
1 INR
2 USD
3 SGD
4 EURO
. .
. .

When I fire a query like, select * from Currecny, I get the recordset as shown.

But I want to get " SGD " as my first record, then all remaining records.

How can I get this?

Any help appreciated.

Thanks,
Lok.

Posted 22-Dec-11 18:22pm

Lokesh Zende

Updated 22-Dec-11 19:47pm

RaisKazi

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Accepted Answer · 2011-12-22T19:01:00

Solution 2

Amir's answer is enough but here alternative solution
Add an another column in your table(Ex. Default or DisplayOrder), see below table.

ID Name IsDefault
-----------------
1 INR   N
2 USD   N
3 SGD   Y
4 EURO  N

Use the Below Query

SQL

SELECT * FROM [Table] ORDER BY SGD DESC

ID Name DisplayOrder
-----------------
1 INR   2
2 USD   3
3 SGD   1
4 EURO  4

SQL

SELECT * FROM [Table] ORDER BY DisplayOrder

Posted 22-Dec-11 19:01pm

thatraja

Comments

Amir Mahfoozi 23-Dec-11 1:05am

+5 Yes, I always use display order in my own projects :)

Rakshith Kumar 15-Oct-13 5:22am

nice one :)

RaviRanjanKr 23-Dec-11 1:36am

5+

Scubapro · Accepted Answer · 2011-12-22T19:53:00

Solution 3

SQL

select * from currency
order by
case name
when 'SGD' then 1
else 2
end

Posted 22-Dec-11 19:53pm

Scubapro

Comments

Amir Mahfoozi 23-Dec-11 4:36am

+5 Another good solution.

Scubapro 23-Dec-11 4:38am

Tnx!

Amir Mahfoozi · Accepted Answer · 2011-12-22T18:33:00

Solution 1

Try this :

SQL

select * from currency where id=3
union all 
select * from color where id<>3

Posted 22-Dec-11 18:33pm

Amir Mahfoozi

Comments

thatraja 23-Dec-11 1:02am

5!

RaviRanjanKr 23-Dec-11 1:36am

My 5+

Lokesh Zende 23-Dec-11 3:11am

Thanks Amir... :)

Amir Mahfoozi 23-Dec-11 4:27am

You're welcome :)