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 different types of functions in sql?

511

What version is sql?

551

what are the types of join and explain each? : Sql dba

530

Can I call a procedure inside a function?

549

explain mysql aggregate functions. : Sql dba

545

What does (*) mean in sql?

527

Describe different types of general function used in sql?

530

What does the acronym acid stand for in database management?

540

Is sql injection illegal?

595

What is a dynamic query?

569

How do I add a database to sql?

573

Show the two pl/sql cursor exceptions.

612

what is a composite key ? : Sql dba

596

who introduced sql?

566

Are left and right joins the same?

529