select distinct col1 from samp where col1 is not null union all select d

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

Question Posted / ajitnayak

6 Answers
13510 Views
TCS, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

what is foreign key? : Sql dba

1000

What is the difference between sum and count in sql?

972

How to pronounce postgresql?

1032

What are stored procedures in mysql?

1002

differentiate between float and double. : Sql dba

1035

Can we alter stored procedure?

967

which tcp/ip port does sql server run on? : Sql dba

1002

how to return query output in html format? : Sql dba

1059

What are the query optimization techniques?

913

What is the use of primary key?

994

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1080

How to select all records from the table?

1115

What is graph sql?

972

Describe different types of general function used in sql?

1014

Explain about various levels of constraint.

921