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 sub-query? : Transact sql

1091

How many types of relationship are there?

1023

What is the difference between clustered and non-clustered indexes?

1081

What is sqlite format?

1183

Does user triggers have entry for trigger with compilation errors?

1024

What is dml with example?

1076

Can we use rowid as primary key?

979

what is offset-fetch filter in tsql? : Transact sql

938

Are pl sql variables case sensitive?

1039

What is keys and its types?

1069

define sql delete statement ? : Sql dba

1005

What is bulk compiling in pl/sql.?

1121

What is a heap in sql?

1053

What is the use of & in pl sql?

1036

How to add new employee details in an employee_details table with the following details

1085