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
- 12828 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
How do rank () and dense_rank () differ?
What are the different tcl commands in sql?
What is difference between sql and oracle?
how can we know the number of days between two given dates using mysql? : Sql dba
What is program debugging?
How do I truncate a sql log file?
Are pl sql variables case sensitive?
Can we use joins in subquery?
How do I install sql?
What is the difference between in and between in sql?
What is a procedure in pl sql?
How do you change a value in sql?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What is triggering circuit?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
