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
How many subqueries can be nested in a statement?
How to select random rows from a table?
How do you exit in sql?
What is the difference between local variables and global variables?
how to calculate the difference between two dates? : Sql dba
What is a primary key example?
What is latest version of sql?
Is record in pl sql?
what are the 'mysql' command line arguments? : Sql dba
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
What are the basic techniques of indexing?
how to enter characters as hex numbers? : Sql dba
Is sql pronounced sequel or sql?
What are the differences between implicit and explicit cursors?
How do I quit sql?