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

how many ways we can we find the current date using mysql? : Sql dba

I want to know the difference between A Record Type and a Table.

how to create a primary key with out creating an index?

Which function is used to return remainder in a division operator in sql?

write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

How to run sql commands in sql*plus?

how do you login to mysql using unix shell? : Sql dba

What is write ahead logging in sql server?

What does select count (*) mean in sql?

What does sign mean sql?

What is the use of pl/sql table?

What is embedded sql what are its advantages?

For more SQL PLSQL Interview Questions Click Here