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
4044 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 would you go about verifying the network name that the local_listener is currently using?

2053

Is oracle a programming language?

998

Explain alias?

1154

What is a nested table?

1071

Explain oracle’s server parameter file.

1001

How to rebuild an index in oracle?

1033

How to create a stored function in oracle?

1115

How to add another datafile to a tablespace?

1047

What do you mean by a database transaction & what all tcl statements are available in oracle?

996

What are the differences between interval year to month and interval day to second?

1032

What is the string concatenation operator in oracle?

1183

What privilege is needed for a user to connect to oracle server?

998

How a tablespace is related to data files?

1113

How to create an initialization parameter file?

1060

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2299