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

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 / ramya

Answer Posted / ramya

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

Is This Answer Correct ?

18 Yes

2 No

Please Help Members By Posting Answers For Below Questions

what are the limitations of identity column? : Transact sql

594

How does join work in sql?

544

Is trigger a stored procedure?

494

explain what is mysql? : Sql dba

586

what are string data types? : Sql dba

498

What is meant by user defined function?

573

What is natural join in sql?

528

Is subquery faster than join?

562

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

555

Differentiate between pl/sql and sql?

605

What are conditional predicates?

577

What are different types of tables in sql?

522

Which is better join or subquery?

596

What is field delimiter?

625

How do I remove sql developer from windows 10?

498