Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 14823 Views
- Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / lavanya
suppose we hav,table name: demo
values
------
1
2
3
NULL
3
4
1
5
NULL
select values from demo where values!=NULL
| Is This Answer Correct ? | 0 Yes | 8 No |
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
How to run pl/sql statements in sql*plus?
What is t sql in sql server?
What is a mutating table and a constraining table?
what is the output of this query selet * from employee where 1=2 ??
Is a foreign key always unique?
What is the difference between delete, truncate and drop command?
How to install oracle sql developer?
What is user define exception and example
Is sql open source?
What is the starting oracle error number? What is meant by forward declaration in functions?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
