1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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 / dinesh


write a query filter the null value data following source? name age john 30 smith null null ..

Answer / ramya

select * from test_1 where name is not null and age is not
null;

Is This Answer Correct ?    18 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

What is sql catalog?

0 Answers  

define sql insert statement ? : Sql dba

0 Answers  

Why procedure is used in sql?

0 Answers  

display your age in months?

2 Answers  

What is a transaction?

5 Answers  




Is stored procedure faster than query?

0 Answers  

What is trigger in pl sql?

0 Answers  

Is primary key is clustered index?

0 Answers  

What is the difference between delete and truncate commands?

0 Answers  

What are pl sql procedures?

0 Answers  

what is self-join? : Sql dba

0 Answers  

what are date and time data types in mysql? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories