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
4016 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

What is the quickest way to export a table to a flat file?

960

What is a sub query? What are its various types?

1164

What is a trigger and what are its types in oracle?

1062

What are data pump export and import modes?

1058

What is recovery manager in Oracle?

1048

Will you be able to store pictures in the database?explain.

990

How to run the anonymous block again?

1123

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1007

What happens to the current transaction if a ddl statement is executed?

1006

What are the benefits of ordbms?

1081

Explain parameter file in oracle.

1020

State the various uses of dbcc command?

1050

How to retrieve data from an cursor to a record?

1095

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2299

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2362