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
7853 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 t sql a programming language?

1073

how to do backup entire database? : Transact sql

1151

What is pragma in pl sql?

1120

What is primary key sql?

1046

What is t sql used for?

1020

Why having clause is used in sql?

987

What is the difference between clustered and non-clustered indexes?

1098

What is the difference between delete and truncate statement in sql?

1079

Name three sql operations that perform a sort.

1019

how to use in conditions? : Sql dba

1019

what is foreign key? : Sql dba

1065

Can a key be both primary and foreign?

1004

What is the sql query to display the current date?

1053

What is %type in sql?

971

What are the events on which a database trigger can be based?

1198