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
4038 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 a dead lock in oracle?

1120

How to find out what oracle odbc drivers are installed?

1040

Please explain compound trigger in oracle?

1057

What is redo log?

1064

What is MTTR advisor in Oracle?

1090

What is tns entry?

1149

What happens if variable names collide with table/column names?

1191

What is oracle database client?

1032

Is oracle an operator?

923

How can you use check constraints for self referential integrity?

969

What is blob datatype?

1128

What are the uses of a database trigger?

994

What are the uses of Database Trigger ?

1719

definition of cluster and non-clustered index?

3033

How do I escape a reserved word in oracle?

1197