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

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2215

Can we write insert statement in function in oracle?

1038

What is a server parameter file in oracle?

1013

How to calculate date and time differences in oracle?

1001

How to create a table in a specific tablespace?

925

What are the benefits of ordbms?

1032

What are the varoius components of physical database structure of oracle database?

953

1) Does oracle have any table which contain all the exceptions and it's code internally?

1712

What is the string concatenation operator in oracle?

1106

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1052

Explain coalesce function?

1133

What privilege is needed for a user to create views in oracle?

990

Explain rename?

933

What is Data Dictionary Cache in Oracle?

1126

How to use regular expression in pattern match conditions in oracle?

980