Hi ,
I have this table -
create table t(id int , x1 int,x2 int,x3 int ,x4 int ,x5 int );
insert into t select 5555,4,3,5,2,1
i was able to take the minimum value for id 5555 which is 1 , but i also need to take the column name for this values - means x5 .
How can i do it ?