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 column in a table?

1126

What steps server process has to take to execute an update statement?

976

Can we change the table name in sql?

941

Can we create table inside stored procedure?

956

How can we link a sql database to an existing android app?

1030

What is normalization in sql?

1016

What is cursor in pl sql?

1119

Can sql developer connect to db2?

1053

What are tuples in sql?

1136

what are the different type of sql's statements ? : Sql dba

926

What is snowflake sql?

1075

What is an emotional trigger?

1005

What is sql injection vulnerability?

945

Can we perform dml in function?

1068

What is the difference between left join and right join?

946