Need help on the query to remove Null records
448749Apr 13 2009 — edited Nov 4 2010Hi,
I have a table with the following data.
COL1 COL2 COL3
1 a1 NULL NULL
2 b1 NULL x3
3 c1 NULL y3
4 NULL d2 z3
5 NULL a2 NULL
6 NULL c2 NULL
7 NULL b2 NULL
I want to get output like this: (i.e. All null values have to be eliminated from the all the columns).
COL1 COL2 COL3
1 a1 d2 x3
2 b1 a2 y3
3 c1 c2 z3
4 NULL b2 NULL
Is there any way to get it achieved thru a query?
Thanks,
GV
Edited by: GV2 on Apr 13, 2009 8:03 AM