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);
- 11 Answers
- 13412 Views
- Satyam, I also Faced
- E-Mail Answers
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 unique keys be null?
what is a trigger in mysql? : Sql dba
what is union? : Sql dba
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
What is the difference between numeric and autonumber?
How can we implement rollback or commit statement in a trigger?
What is data type in database?
What does bitemporal mean?
What is sql trigger example?
Does a primary key have to be a number?
What is the use of primary key?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
how does a local variable is defined using t-sql? : Transact sql
Name some usages of database trigger?
How to take user input in pl sql?
