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
15243 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

What is difference between inner join and self join?

1079

what tools available for managing mysql server? : Sql dba

1078

What is mutating error in pl sql?

1013

what are local and global variables and their differences? : Sql dba

1070

What is java sql drivermanager?

1086

What is rtm in testing?

1105

What are analytical functions in sql?

1026

What is difference between sql and oracle?

1122

What is the difference between sum and count in sql?

984

what is blob? : Sql dba

1144

What does select top 1 do in sql?

1089

What are the dml statements?

1141

How do I start pl sql?

945

What is lexical units in pl sql?

1144

What are stuff and replace function?

1076