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

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

Question Posted / ashish joshi

1 Answers
1002 Views
I also Faced
E-Mail Answers

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

Answer / 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

More Data Warehouse General Interview Questions

Explain me what are conformed dimensions?

1 Answers

What is Star Schema?

1 Answers Informatica,

Explain where do we use semi and non additive facts?

1 Answers

What is surrogate key?

5 Answers IBM, Informatica,

What are the different methods of loading dimension tables?

1 Answers

What are modeling tools available in the market?

1 Answers

Explain the different types of data warehousing?

1 Answers

What are components of report studio?

1 Answers

Describe a data warehouse.

1 Answers

What are data modeling and data mining?

1 Answers

Which component has onread method and what it is used for?

1 Answers

How does data mining and data warehousing work together?

2 Answers

For more Data Warehouse General Interview Questions Click Here