Hi Ramkrish, select *from k; SNO ----- 1 2 3

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 / srinu

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

Answer Posted / srinu

Hi Ramkrish,

select *from k;

SNO
-----
1
2
3

3
4

9 rows selected

select sno from k where sno is not null;

SNO
-----
1
2
3
3
4

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

List the different type of joins?

1111

what is a record in a database ? : Sql dba

1102

Can we use two order by clause in query?

1015

What is sqlca in db2?

1031

What are user defined functions?

1056

What is sql basics?

1078

How can you save or place your msg in a table?

1032

What is the use of sqlerrd 3?

993

Show the two pl/sql cursor exceptions.

1252

What are the different dml commands in sql?

1241

what are the different type of normalization? : Sql dba

1063

Is big data nosql?

995

What is latest version of sql?

1096

What are secondary keys?

1028

Is sql a case sensitive language?

1007