1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / dinesh


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

What is the benefit of foreign key?

0 Answers  

can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures?

2 Answers   Fujitsu,

What does “select count(1) from tab” result?

10 Answers   IBM,

What are different clauses used in sql?

0 Answers  

What is foreign key sql?

0 Answers  




Mention what problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  

How to avoid duplicate records in a query?

0 Answers  

what eliminate duplicate without using roenum and not

5 Answers   Matrix,

What is record in pl sql?

0 Answers  

Is left join faster than inner join?

0 Answers  

what is sql in mysql? : Sql dba

0 Answers  

how can we find the number of rows in a table using mysql? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories