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 are sql functions? Describe in brief different types of sql functions?

0 Answers  

Is natural join and inner join same?

0 Answers  

How will we see framework of a table?

2 Answers   Accenture,

Difference between table function and pipelined function?

0 Answers  

What are sql triggers used for?

0 Answers  




Does truncate require commit?

0 Answers  

How do you delete duplicates in sql query using rowid?

0 Answers  

How many unique keys can a table have?

0 Answers  

What are inbuilt functions in sql?

0 Answers  

How to Declare Fixed Length String Value In PL SQL

0 Answers  

Is it possible to create the following trigger: before or after update trigger for each row?

0 Answers  

What is linq to sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories