write a query filter the null value data following source? name age john 3

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

More SQL PLSQL Interview Questions

What is integrity constraints?

What can sql server reporting services do?

Difference between views and materialized views?

Can we insert data into materialized view?

How to disable a trigger name update_salary?

What is the difference between clustered and non-clustered index in sql?

Why do we create stored procedures & functions in pl/sql and how are they different?

define sql insert statement ? : Sql dba

how do u call in & out parameters for stored procedures?

What is the best sql course?

What are the two types of exceptions in pl/sql?

What are the two parts of a procedure ?

For more SQL PLSQL Interview Questions Click Here