please use group function is ignore the null values

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

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

Answer Posted / vijay_1994

please use group function is ignore the null values

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 the difference between inner join and natural join?

954

What is duration in sql profiler trace?

1021

What is the maximum number of columns in sql table?

1088

what tools available for managing mysql server? : Sql dba

1008

Does normalization improve performance?

980

What is sql not null constraint?

981

How can you fetch first 5 characters of the string?

946

Why do we use sql constraints?

1123

What is the best partition size for windows 10?

946

What is normalization? How many normalization forms are there?

1010

What is sql comments?

1031

What is varchar used for?

1023

What happens when a trigger is associated to a view?

840

What is the difference between in and between in sql?

994

What is the plv (pl/vision) package offers?

981