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

How do you truncate?

902

What is sql table?

962

what are the disadvantages of mysql? : Sql dba

1146

What are secondary keys?

967

How delete all records from table in sql?

977

what is view? : Sql dba

953

Can a trigger call a stored procedure?

1064

What is sql stand for?

979

difference between anonymous blocks and sub-programs.

1130

Is sql sequential or random?

1026

What is materialized view in sql?

916

What are the properties of a transaction?

1128

How do I get sql certification?

965

What is the difference between left outer join and left join?

991

What is difference between sql and mysql?

1121