Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


write a query filter the null value data following source?
name age
john 30
smith null
null 24
sharp 35
i want output

name age
john 30
sharp 35



write a query filter the null value data following source? name age john 30 smith null null ..

Answer / ramya

select * from test_1 where name is not null and age is not
null;

Is This Answer Correct ?    18 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

Can u create a primary key with out unique index.

8 Answers  


What is the difference between null value, zero, and blank space?

0 Answers  


Is pl sql a programming language?

0 Answers  


How many functions are there in sql?

0 Answers  


Can we rollback delete command?

0 Answers  






what is a materialized view? : Sql dba

0 Answers  


What is pl sql in dbms?

0 Answers  


what is cursor procedure

1 Answers   iGate,


wtite down triggr not any entry on Sunday

2 Answers   NIT,


what is External tables? explain with examples

2 Answers   TCS,


What is the difference between partition and index?

0 Answers  


what is a foreign key ? : Sql dba

0 Answers  






Categories