write a query filter the null value data following source? name age john 3

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

1 Answers
5447 Views
TCS, I also Faced
E-Mail Answers

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 the query optimization techniques?

0 Answers

differentiate between float and double. : Sql dba

0 Answers

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

2 Answers

Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

5 Answers CGI,

What is a temporal table?

0 Answers

what are different types of keys in sql?

0 Answers

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

0 Answers

What is the use of primary key?

0 Answers

How can you create Cursor with parametres ?

3 Answers

What is sql profiling in oracle?

0 Answers

what are date and time data types? : Sql dba

0 Answers

Can you call pl/sql package functions from within a fast formula?

0 Answers

For more SQL PLSQL Interview Questions Click Here