Thanks for replying,
I had another doubt
After Running the below Select Statement what you given for example my records are like below,
SELECT Name,
MIN(case when Unit = 'tt' then ISNULL(Figure,0) end) as tt,
MIN(case when Unit = 'm' then ISNULL(Figure,0) end) as m,
MIN(case when Unit = 'ft' then ISNULL(Figure,0) end) as ft
FROM TBL_SAMPLE
group by name
Name tt m ft
---------------------------------------
ABC 20 10 NULL
PQR 30 90 NULL
XYZ 60 15 NULL
Now my requirement is if ft = NULL then i want to do ( m/tt ) so now the total records i want to display is,
Name tt m ft
---------------------------------------
ABC 20 10 0.5
PQR 30 90 3
XYZ 60 15 0.25
so this is my final result
how to resolve this.
Thanks in Advance.