select id,name from table where id is not null;

write a query to remove null following table are
id name
101 dinesh
null jyothi
null bharathi
102 suresh
null shilpha
103 prakesh
null suma

i want the output format like

id name
101 dinesh
102 suresh
103 prakesh

Question Posted / sumit

3 Answers
7967 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / sumit

select id,name from table where id is not null;

Is This Answer Correct ?

4 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are myisam tables? : Sql dba

1079

What are triggers in sql?

1061

how does a local variable is defined using t-sql? : Transact sql

1060

Is sql open source?

1026

Name the operator which is used in the query for pattern matching?

1004

What is lexical units in pl sql?

1209

How to select all records from the table?

1182

What is not null in sql?

1109

What are the types of join in sql?

1149

Could you please provide oca (oracle 10g) dumps for my certification ?

5244

what is sp_pkeys? : Transact sql

1206

Can we use two order by clause in query?

1018

Why we use stored procedure instead of query?

1048

What is the mutating table and constraining table?

1084

What is the difference between pl and sql?

1153