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 the plv (pl/vision) package offers?

1110

What can I use instead of union in sql?

1018

What is not in sql?

995

What does fetching a cursor do?

1129

How many types of tables are there?

994

What is application trigger?

1049

How do you declare a user-defined exception?

1070

Can you have more than one key in a database?

986

How many types of functions are there in sql?

1001

What are sql ddl commands?

1134

What is the use of double ampersand (&&) in sql queries? Give an example

1187

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1117

How to select 10 records from a table?

1204

Is join an inner join?

1019

What is sql server and ase?

1066