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 is the most common sql injection tool?

1010

What if we write return in procedure?

1364

How to pipe multiline string to isql?

976

describe transaction-safe table types in mysql : sql dba

964

Can we enter data in a table in design view?

922

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1004

what are ddl statements in mysql? : Sql dba

1133

does sql support programming? : Sql dba

1005

What is a nested table in word?

929

What is trigger explain it?

975

What type of database is cloud sql?

1057

What is on delete set null?

1050

Define tables and fields in a database

1093

What is bind reference and how can it be created?

984

What does sql stand for?

954