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
15331 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 subquery? : Sql dba

1142

Does sql backup shrink transaction log?

989

What is materialized view in sql?

928

Can we call stored procedure in function?

971

What is the difference between microsoft access and sql?

1037

How do you update a value in sql?

1058

How do I run a pl sql program?

1140

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1104

Differentiate between pl/sql and sql?

1161

Explain the components of sql?

1070

Explain what is a view?

1070

How do you go back in sql?

994

What is sql partition function?

1220

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2094

Is left join faster than inner join?

1136