write a query to remove null following table are id name 101 dinesh nul

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

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

Answers were Sorted based on User's Feedback

write a query to remove null following table are id name 101 dinesh null jyothi null bha..

Answer / kart

select * from table where id is not null;

Is This Answer Correct ?

17 Yes

3 No

write a query to remove null following table are id name 101 dinesh null jyothi null bha..

Answer / sumit

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

Is This Answer Correct ?

4 Yes

0 No

write a query to remove null following table are id name 101 dinesh null jyothi null bha..

Answer / ajit nayak

Delete from <tab_name>
where id is null;

Is This Answer Correct ?

4 Yes

0 No

Post New Answer