suppose u have table named as emp emp_id dept_id last

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);

Question Posted / pankaj

11 Answers
14916 Views
Satyam, I also Faced
E-Mail Answers

Answer Posted / pankaj

suppose u have table named as emp

emp_id dept_id last_name salary

1 10 N1 10000

2 20 N2 10000

3 N3 12000

4 N4 12000

5 30 N5 15000

NOW IF U WANT TO RETRIEVE THE ROWS WITH ELIMINATING NULL
VALUES.

EX-

SELECT EMP_ID,DEPT_ID,LAST_NAME,SALARY
FROM EMP
WHERE DEPT_ID IS NOT NULL;

SO IN THE OUTPUT NULL VALUES WILL NOT BE RETRIVED MEANS
RECORD FOR EMP_ID 3 AND 4 WILL NOT BE RETRIVED.

REGARDS R

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we create foreign key without primary key?

943

What are the three forms of normalization?

1008

Can you call pl/sql package functions from within a fast formula?

990

discuss about myisam key cache. : Sql dba

992

what are all the different normalizations? : Sql dba

983

Name the different types of indexes in sql and define them.

1094

What is a join?

1031

What are sql commands?

948

what is self join and what is the requirement of self join? : Sql dba

1095

What is query optimization in sql?

950

Where can I learn sql for free?

952

What are stored procedures used for?

972

What is coalesce in sql?

994

How do I count rows in sql?

962

What is foreign key sql?

954