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
7799 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

What is coalesce in sql?

1035

How many commands are there in sql?

1010

What is the difference between sql and isql*plus?

1073

Can 2 queries be executed simultaneously in a distributed database system?

1132

explain advantages of innodb over myisam. : Sql dba

1113

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3988

How many times can we commit in a loop?

1000

What is compound trigger?

1016

How does a trigger work?

1043

what is view? : Sql dba

942

Why is a trigger used?

926

What is difference between rank () row_number () and dense_rank () in sql?

1090

how to use regular expression in pattern match conditions? : Sql dba

1015

What is the difference between join and natural join?

915

What is the difference between local variables and global variables?

1109