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
- 2 Answers
- 3191 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
How do I know if oracle client is installed on windows?
How do I start tns listener?
In oracle there is column command, how will you explain that?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
How to select all columns of all rows from a table in oracle?
How to create additional tablespaces for an new database?
How to start a new transaction in oracle?
What is a connect identifier?
Can we store images in oracle database?
How does the on-delete-cascade statement work?
Explain oracle’s server parameter file.
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
What is the difference between count (*), count (expression), count (distinct expression)?
What do you mean by a tablespace?
