SELECT MAX(CASE WHEN Seq=1 THEN [Value] ELSE NULL END) AS MaxA,
MAX(CASE WHEN Seq=2 THEN [Value] ELSE NULL END) AS MaxB,
MAX(CASE WHEN Seq=3 THEN [Value] ELSE NULL END) AS MaxC,
MAX([Value]) AS MaxAll
FROM
(
SELECT a as Value,1 AS Seq
FROM YourTable
UNION ALL
SELECT b,2
FROM YourTable
UNION ALL
SELECT c,3
FROM YourTable
)t

quote:

---

Originally posted by sadaiyan

Hello tkizer,
Thanks to reply me, in this solution what is dt

select max(MaxColumn) as MaxColumn
from
(select max(a) as MaxColumn from table union select max(b) from table union select max(c) from table) dt


sadaiyan.l

sadaiyan.l

---

quote:

---

Originally posted by khtan

quote:

---

Originally posted by sadaiyan

Hello tkizer,
Thanks to reply me, in this solution what is dt

select max(MaxColumn) as MaxColumn
from
(select max(a) as MaxColumn from table union select max(b) from table union select max(c) from table) dt


sadaiyan.l

sadaiyan.l

---

Post to the wrong thread ? I don't see Tara's post here

---

KH
Time is always against us

---