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
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
What is the quickest way to export a table to a flat file?
What is a sub query? What are its various types?
What is a trigger and what are its types in oracle?
What are data pump export and import modes?
What is recovery manager in Oracle?
Will you be able to store pictures in the database?explain.
How to run the anonymous block again?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
What happens to the current transaction if a ddl statement is executed?
What are the benefits of ordbms?
Explain parameter file in oracle.
State the various uses of dbcc command?
How to retrieve data from an cursor to a record?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
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.