wirte a query to remove null? following table are
col1 col2 col3
dinesh null null
null suresh null
null null prakesh
i want the output like
col1 col2 col3
dinesh suresh prkaesh
Answer Posted / ajitnayak
select distinct col1 from samp
where col1 is not null
union all
select distinct col2 from samp
where col2 is not null
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is foreign key? : Sql dba
What is the difference between sum and count in sql?
How to pronounce postgresql?
What are stored procedures in mysql?
differentiate between float and double. : Sql dba
Can we alter stored procedure?
which tcp/ip port does sql server run on? : Sql dba
how to return query output in html format? : Sql dba
What are the query optimization techniques?
What is the use of primary key?
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
How to select all records from the table?
What is graph sql?
Describe different types of general function used in sql?
Explain about various levels of constraint.