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

How do I find duplicates in two columns?

1268

how to shutdown mysql server? : Sql dba

1150

What does where 1 1 mean in sql?

1079

Where do we use pl sql?

1052

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

1194

What is indexes?

1122

How do I find sql profiler?

992

What is column?

1036

What is the difference between Union and Union all. Which is faster.

1443

Can primary key be changed?

957

what is the difference between a local and a global temporary table? : Sql dba

1132

How do I start sql profiler?

1048

What is bind reference and how can it be created?

1070

What are functions in sql?

999

what are the disadvantages of mysql? : Sql dba

1212