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

How much does sql cost?

1067

Can we join same table in sql?

1066

What are all different types of collation sensitivity?

1075

Can we join more than 2 tables in sql?

1093

what are local and global variables and their differences? : Sql dba

1134

Can a table have no primary key?

1110

How can we store rows in PL/SQL using array?

1268

Why is pl sql needed?

1004

What is a join query?

1002

When is the update_statistics command used?

1182

What's the difference between inner join and left join?

1039

How to use transactions efficiently : transact sql

1114

Does sap use sql?

1040

How do you explain an index number?

1185

What is indexing in sql and its types?

1132