select distinct((select col1 from z1 where no is not null))col1,(select col

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 / apsar

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

Answer Posted / apsar

select distinct((select col1 from z1 where no is not null))col1,(select col2 from z1 where sal is not null)col2,select col3 from z1 where col is not null) from z1
Hint:z1 is Table Name

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why do we need cursors in pl sql?

1001

Why trigger is used in sql?

914

What is the order of sql select?

985

Define join and name different types of joins?

957

Which join is like inner join?

974

How to write pl sql program in mysql command prompt?

1007

What is difference between table and view?

974

How do you determine the current isolation level? : Transact sql

1067

What is normalization in a database?

1104

how to convert numeric values to character strings? : Sql dba

1034

What is trigger and stored procedure in sql?

976

Can we use the cursor's to create the collection in PL/SQL?

958

what are the performance and scalability characteristics of mysql? : Sql dba

942

Is pl sql different from sql?

935

Can we commit inside a trigger?

942