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 / chandra shekhar
Dear Lavanya,
You cannot equate the NULL with the operators like = and !=
NULLs can be equated with "IS NULL" or "IS NOT NULL"
(Double quotes " not included)
In u r query if u say IS NOT NULL, then also as per question asked in the very beginning it will not suffice.
As there are multiple columns with multiple NULLs in all the given columns .
Regards
J
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is optimistic concurrency control? : Transact sql
What is time based sql injection?
How do you get column names only for a table (sql server)?
When is the update_statistics command used?
What does plv msg allows you to do?
What is Collation Sensitivity ? What are the various type ?
Is there a 64 bit version of ssms?
What is output spooling in sql*plus?
What can sql server reporting services do?
What are the different types of tables in sql?
What is a temporal table?
what are wild cards used in database for pattern matching ? : Sql dba
How do you write an inner join query?
What is string data type in sql?
What is the order of sql select?