display null value rows with out using null function?
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 |
Post New Answer View All Answers
What is the most common sql injection tool?
What if we write return in procedure?
How to pipe multiline string to isql?
describe transaction-safe table types in mysql : sql dba
Can we enter data in a table in design view?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
what are ddl statements in mysql? : Sql dba
does sql support programming? : Sql dba
What is a nested table in word?
What is trigger explain it?
What type of database is cloud sql?
What is on delete set null?
Define tables and fields in a database
What is bind reference and how can it be created?
What does sql stand for?