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

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1096

how can we know the number of days between two given dates using mysql? : Sql dba

1031

How do you write an inner join query?

937

what is query cache in mysql? : Sql dba

1017

What are inner outer left and right joins in sql?

1002

What do you mean by stored procedures? How do we use it?

989

How to process query result in pl/sql?

1109

how to run 'mysql' commands from a batch file? : Sql dba

1094

Is stored procedure faster than query?

953

How can we optimize a sql query?

1034

How bulk collect improves performance?

986

How to fetch alternate records from a table?

1213

What is a database event trigger?

1138

What is break?

1185

Explain the methods used to protect source code of pl/sql.

1010