Hi All,
I am new to mysql, can any one help me to solve this problem,
i have a query, based on the condition i have to get two fields from the same table,
how to solve this problem,
select
(case
when hor_val>0 then hor_desc,hor_val
end) from temp
hor_val is a integer filed, hor_desc is a varchar field,
based on the har_val i have to get hor_desc and hor_val as output.
please give the solution, as earlier as possible.