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 an oracle stored procedure?

987

what is the different between now() and current_date()? : Sql dba

934

How much does sql cost?

930

What is the difference between a query and a report?

901

What information is needed to connect sql*plus an oracle server?

978

explain the options of myisamchk to improve the performance of a table. : Sql dba

950

What is fmtonly in sql?

1008

Mention what does the hierarchical profiler does?

1021

List and explain the different types of join clauses supported in ansi-standard sql?

1300

How does postgresql compare to oracle/db2/ms sql server/informix?

981

What are the sql versions?

894

what is the difference between $message and $$message? : Sql dba

944

Enlist the data types that can be used in pl/sql?

1002

how to drop an existing index in mysql? : Sql dba

1017

What are all ddl commands?

1014