how to eliminate null values in a column i.e
table vlaues
1 2 3
NULL 3 4
1 5 NULL
i want output like this
1 2 3
3 4
1 5
i dnt want to use nvl is null and i dnt want replace the
NULL value with any value i.e nvl(col,o);
Answer Posted / srinu
Hi Ramkrish,
select *from k;
SNO
-----
1
2
3
3
4
9 rows selected
select sno from k where sno is not null;
SNO
-----
1
2
3
3
4
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can triggers stop a dml statement from executing on a table?
what is a relationship and what are they? : Sql dba
Explain the order of sql statement execution?
How to call a javascript function from pl sql?
How many joins in sql?
What is user in sql?
Is it possible to link two groups inside a cross products after the cross products group has been created?
Which one is better subquery or joins?
What is acid property in a database?
How to select 10 records from a table?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What is sql stand for?
Define sql delete statement.
Explain constraints in sql?
what is online transaction processing (oltp)? : Sql dba