How to use a case statement in a SQL query? [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 6 years ago.

Improve this question

How to replace NULL value of specific column with other column value. For example: If second name of customer is not given then add father name in second name column.

Possible duplicate of Replacing NULL with 0 in a SQL server query — Magnus
– Magnus, Commented Jul 19, 2019 at 6:18

mkRabbani · Accepted Answer · 2019-07-19 06:10:04Z

1

Try with case statement as below-

SELECT
CASE 
    WHEN second_name IS NULL OR second_name = '' THEN father_name 
    ELSE second_name
END AS second_name
FROM your_table

answered Jul 19, 2019 at 6:10

mkRabbani

16.9k2 gold badges17 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

SANJAY Over a year ago

thanks now there is one more condition of middle name null

mkRabbani Over a year ago

No matter what can be done, its all depends on what you wants? Just explain your requirement. There is always a solution. :)

Fahmi · Accepted Answer · 2019-07-19 06:13:12Z

1

use coalesce()

select coalesce(secondname ,fathername) from tablename

answered Jul 19, 2019 at 6:13

Fahmi

37.5k5 gold badges26 silver badges32 bronze badges

Comments

Biswanath · Accepted Answer · 2019-07-19 06:14:24Z

1

You can use COALESE

SELECT COALESE(second_name, first_name) from mytable;

AFAIK, it is supported on Oracle, MS SQL Server, MySQL and Postgres.

answered Jul 19, 2019 at 6:14

Biswanath

9,19512 gold badges48 silver badges58 bronze badges

Comments

Ravi Koradia · Accepted Answer · 2019-07-19 06:51:12Z

0

You can use ifnull function as well. The syntax should be like :

select ifnull(second_name,father_name) from user;

answered Jul 19, 2019 at 6:51

Ravi Koradia

9697 silver badges15 bronze badges

Comments

Nilanshu Ramteke · Accepted Answer · 2019-07-19 07:41:35Z

0

SELECT COALESCE(NULLIF(second_name, ''), father_name) from table

You can handle blank and NULL values in the second_name column and if these values are there it will show value from father_name column

answered Jul 19, 2019 at 7:41

Nilanshu Ramteke

1

Collectives™ on Stack Overflow

How to use a case statement in a SQL query? [closed]

5 Answers 5

2 Comments

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

Comments

Comments

Comments

Linked

Related