Select Empno, Decode (Comm,Null,0,Comm) Comm From Emp; Select Empno, Cas

display null value rows with out using null function?

Question Posted / noor

Answer Posted / noor

Select Empno, Decode (Comm,Null,0,Comm) Comm From Emp;

Select Empno, Case When Comm Is Null Then 0 Else Comm End Comm From Emp

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the 3 modes of parameter?

1154

How to select 10 records from a table?

1157

What is dbo in sql?

962

What are the two different parts of the pl/sql packages?

1087

Explain select statements in sql?

1057

Does sql support programming?

1070

What is the difference between sql and isql*plus?

1095

How do I count rows in sql?

1004

What does <> sql mean?

1090

What is the importance of sqlcode and sqlerrm?

1356

What is sqlca in db2?

963

Is there any restriction on the use of union in embedded sql?

1157

Is left join and outer join same?

1069

What is normalization sql?

1057

Can I create table without primary key?

997