select c from tablename where c IS NOT NULL;

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT)
Write the query plz.

A B C
================
1 NULL 2
NULL 3 4
NULL 5 6
7 NULL NULL

O/P

C
=
2
4
6

Question Posted / ravi gali

2 Answers
3904 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / ravi gali

select c from tablename
where c IS NOT NULL;

Is This Answer Correct ?

2 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain table?

1057

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2900

Explain do view contain data?

938

What is not equal to in oracle?

949

Is there a combination of "like" and "in" in sql?

1003

How do we represent comments in oracle?

999

Can a formula column be obtained through a select statement ?

2262

What is a snapshot log?

948

Explain about the analyze command in oracle?

995

Why does for update in oracle 8 cause an ora-01002 error?

931

Can group functions be used in the order by clause in oracle?

939

What do you mean by merge in oracle and how can we merge two tables?

1000

How to update values on multiple rows in oracle?

969

How to create an oracle testing table?

1005

types of indexes and the rationale behind choosing a particular index for a situation.

2443