In sql query using case when?

Posted by Karthik2010_Mca under Interview Questions on 3/26/2013 | Points: 10 | Views : 2166 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi,

In Sql server have below mentioned table.
Name Age
Karthik 26
Kumar 18
Mala 16
Keyan 28

I want output like this below,

Name Status
Karthik Adult
Kumar Major
Mala Minor
Keyan Adult

I write a query below mentioned,
select Name,
case
when Age=26 then 'Adult'
when Age=18 then 'Major'
when Age=16 then 'Minor'
when Age=28 then 'Adult'
End As [Status] From tbName

But In future I add one or more records in that table, Then How can we proceed this without alter the query.

Thanks in advance
KarthiK.K

Karthik

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Jayakumars on: 3/26/2013 [Member] [MVP] Bronze | Points: 25

0	hi when will created the query First Time put ur value ELSE part select Name, case when Age=26 then 'Adult' when Age=18 then 'Major' when Age=16 then 'Minor' when Age=28 then 'Adult' ELSE 'Test' End As [Status] From tbName Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Karthik2010_Mca, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts