CASE statement in SQL server for all other values

Question

0.00/5 (No votes)

See more:

I have a table like

Id Name Group
100 venki
100 suresh
105 ramu
101 gopi
105 pavan
119 rama
120 meghana
125 mounika
130 Jyothi

I need to show the values in group column..below is the selection criteria

If ID=100 THEN 'Group-A'
ID=105 THEN 'Group-B'
All Other values = 'Group-C'

Can anyone please help me how to write CASE statement for this requirement??

Thanks in Advance

SQL

<pre lang="SQL"><pre lang="SQL"><pre lang="SQL">

What I have tried:

I tried like below

CASE
WHEN ID =100 THEN 'GROUP-A'
WHEN ID= 105 THEN 'GROUP-B'
....
END

But I don't know how to write CASE for "All Other Values".

Posted 27-Apr-16 1:02am

Member 11931581

Updated 27-Apr-16 1:15am

Add a Solution

2 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)

Tomas Takac · Accepted Answer · 2016-04-27T01:10:00

Solution 1

Next time read the documentation documentation[^].

SQL

CASE 
WHEN ID =100 THEN 'GROUP-A' 
WHEN ID= 105 THEN 'GROUP-B'
ELSE 'Group-C'
END

Posted 27-Apr-16 1:10am

Tomas Takac

Comments

OriginalGriff 27-Apr-16 7:17am

Simple, and to the point! :thumbsup:

Member 11931581 27-Apr-16 7:35am

Thank you!!

kedar001 · Accepted Answer · 2016-04-27T01:15:00

Solution 2

try

SQL

SELECT 
  *
   ,Case 
         WHEN  ID =100 THEN 'GROUP-A' 
         WHEN  ID= 105 THEN 'GROUP-B'
         ELSE  'Unknown'
   END

Posted 27-Apr-16 1:15am

kedar001