How to use the IF condition in select statement....

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

E_ID     E_IP         E_TYPE
E00003	192.168.0.131	E
E00003	192.168.0.131	B
E00003	192.168.0.131	B
E00003	192.168.0.131	E
E00003	192.168.0.131	E
E00003	192.168.0.131	B
E00003	192.168.0.131	X
	192.168.0.131	X
E00003	192.168.0.131	E
E00004	192.168.0.131	B

I want select sql query using IF condition...If the E_TYPE Column is E and B i want to display the rows of E and B and if E_TYPE column is X i want to display the X rows only....

Posted 1-Oct-11 3:58am

premkumar.r

Add a Solution

Comments

Bala Selvanayagam 1-Oct-11 10:08am

Your required output of the above question is not clear...can you please go into more detail

There is not IF condition in SQL but you may have to use CASE statement...just google for the "SQL case statement".....

1 solution

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)

Sander Rossel · Answer 1 · 2011-10-01T05:44:00

Solution 1

Not sure what you mean, but here is how to use IF... ELSE in SQL[^].
In a SELECT statement it would probably be better and easier to use CASE WHEN... THEN... ELSE...[^].
The MSDN documentation on these is actually pretty good, complete with examples. So I am not going to explain them again here. Simply check out the links and you should manage :)

Posted 1-Oct-11 5:44am

Sander Rossel

Comments

Simon Bang Terkildsen 1-Oct-11 13:12pm

+5It would not only be better and easier to use CASE in a select statement, it's the only option as you can't use if-else in a select statement.

Sander Rossel 1-Oct-11 13:51pm

Thanks :)