In SQL, you can use the COALESCE function or ISNULL function to replace NUL

Suppose we want to display zero when null values coming to report how can we do that?

Question Posted / S K Nigam

1 Answers
999 Views
I also Faced
E-Mail Answers

Answer Posted / S K Nigam

In SQL, you can use the COALESCE function or ISNULL function to replace NULL values with zeros. For example, in MySQL: SELECT COALESCE(column, 0) as column FROM table; In Microsoft SQL Server: SELECT ISNULL(column, 0) as column FROM table;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the purpose of Dataware Control?

1119

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2342

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6072

Explain how to generate iqd file from framework manager?

1020

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1040