Skip to main content

Posts

Showing posts from March, 2013

USING CASE IN SELECT STATEMENT

USING   CASE   IN   SELECT   STATEMENT/ IMPLEMENT IF-THEN-ELSE LOGIC IN SELECT STATEMENT With Example let us understand, How to use CASE Condition in SQL SELECT Statement. I have table EMP having column EMPLOYEEID , MARITALSTATUS , GENDER. Click on pic to enlarge view Say if we want to Display under following condition   If MaritalStatus is M, Then display it as Married, If MaritalStatus is S, then display it as Single and Other than M or S, then Display it as Unknown.   If Gender is M, Then display it as Male, If Gender is F, then display as Female and Other than M or F, then Display it as Unknown. This can be achieved in many ways, for example using REPLACE Function etc, but since my intention is on CASE Statement, I will Continue to demonstrate it using CASE. Let’s do it for Condition 1 first: As per Condition 1, we can use CASE STATEMENT as Shown: SELECT EMPL