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 is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

522

What are the set operators in sql?

549

Is left join same as join?

519

What are the two virtual tables available at the time of database trigger execution?

631

How do temporal tables work?

514

What is the life of an sql statement?

523

What is difference between stored procedures and application procedures?

567

Can we rollback after truncate?

563

what is schema? : Sql dba

560

What are the built in functions of sql?

559

How do you change a value in sql?

552

Can we enter data in a table in design view?

516

What is sqlite used for?

528

Are views faster than queries?

539

what is table? : Sql dba

570