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

what are the authentication modes in sql server? : Sql dba

1047

explain advantages of innodb over myisam. : Sql dba

1115

What is a dynamic query?

1010

What is difference between cursor and trigger?

1057

how to drop an existing view in mysql? : Sql dba

1045

What is the difference between row level and statement level trigger?

1006

Explain mutating table error.

1184

What is null in pl/sql?

1048

What is embedded sql in db2?

999

what is meant by nl2br()? : Sql dba

1015

What is oracle and pl sql?

1108

Why should I use postgresql?

1000

Can we call a function containing dml statements in a select query?

962

Is sql a backend?

1005

how to use myisamchk to check or repair myisam tables? : Sql dba

960