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

Name some usages of database trigger?

1022

What are some emotional triggers?

988

Is left join faster than inner join?

1130

what is a control file ? : Sql dba

1046

What are the three forms of normalization?

1048

What is an intersect?

1110

Explain normalization and what are the advantages of it?

954

Why are sql stored procedures used?

1060

Differentiate between sga and pga.

1168

How can I get the number of records affected by a stored procedure?

1067

What is a native sql query?

1081

how to run 'mysql' commands from a batch file? : Sql dba

1123

what is bcp? When is it used?

1119

Can you sum a count in sql?

1023

how to present a past time in hours, minutes and seconds? : Sql dba

1015