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

Can we create trigger on materialized view in oracle?

1044

What is an oracle table?

1032

How to create a temporary table in oracle?

1331

Explain cascading triggers.

1121

Can you create a synonym without having a table?

1092

How oracle handles dead locks?

1130

What is primefaces used for?

1096

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2173

Oracle

2423

How to resolve the ORA-39133 error in Oracle?

1184

Can we store pictures in the database and if so, how it can be done?

1089

How to open a cursor variable?

1089

What is the parameter mode that can be passed to a procedure?

1109

What is oracle in java?

1017

Explain about integrity constraint?

1177