select * 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 / kart

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

Answer Posted / kart

select * from table where id is not null;

Is This Answer Correct ?

17 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is primary key an index?

1036

Can pl sql procedure have a return statement?

1072

what are the features and advantages of object-oriented programming? : Sql dba

1075

Explain the working of primary key?

1155

What is the difference between instead of trigger and after trigger?

1070

What is a heap in sql?

1148

How do I know if I have sql express or standard?

1067

What is row_number () in sql?

1025

What is meant by <> in sql?

1029

how to select first 5 records from a table? : Sql dba

1029

What is difference between table and view?

1139

What is a .db file?

1043

Can we insert data into view?

950

What are sql*plus environment variables?

1155

Is sql procedural language?

1015