SQL Server Scnerio

Create Table A1
 ( Row1 int,
 Row2 int,
 Row3 int,
 Row4 int)

 Insert into A1 values (0,0,0,18)
 Select * from A1

Row1	Row2	Row3	Row4
0	6	0	0
0	0	30	0
4	0	0	0
0	0	0	18

Select Row1=MAX(Row1),Row2=MAX(row2),Row3=MAX(Row3),Row4=MAX(Row4) From A1

Row1	Row2	Row3	Row4
4	6	30	18