Max Value of Rows in SQL Server-2008

Question

0.00/5 (No votes)

See more:

how to get Max value of (Col1,Col2,Col3) in SQL Server 2008

SQL

ID C1 C2  C3   Result(Max)
T1 1, 3 , 5    5
T2 5, 1,  10   10
T3 8, 15, 2    15

I need Result(Max)

Posted 11-Feb-13 18:04pm

sundar-indo

Updated 11-Feb-13 19:08pm

Aarti Meswania

v2

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

__TR__ · Accepted Answer · 2013-02-11T19:02:00

Solution 1

You can do this using CASE (Transact-SQL)[^].
Here is a sample

SQL

DECLARE @T TABLE
(
	ID VARCHAR(10),
	C1 INT,
	C2 INT,
	C3 INT
)
INSERT INTO @T
SELECT 'T1', 1, 3 , 5 UNION ALL
SELECT 'T2', 5, 1, 10 UNION ALL
SELECT 'T3', 8, 15, 2

SELECT *, CASE WHEN C1 > C2 AND C1 > C3 THEN C1
			WHEN C2 > C1 AND C2 > C3 THEN C2
			ELSE C3 END AS [Result(Max)]
FROM @T

Posted 11-Feb-13 19:02pm

__TR__

Comments

Aarti Meswania 12-Feb-13 1:09am

5+ :)

__TR__ 12-Feb-13 1:31am

Thank you.

sundar-indo 12-Feb-13 1:27am

This is ok, but i need data pull from database.
(1, 3 , 5) * These all value coming from database.
Thanks for your solution.. Its almost ok, need some modification.

__TR__ 12-Feb-13 1:31am

The query I wrote in my solution is just a sample. You can refer it and build your own query.

sundar-indo 12-Feb-13 3:26am

Thanks...
I solved my problem...

SELECT *, CASE WHEN gws1 > gws2 AND gws1 > gws3 THEN gws1
WHEN gws2 > gws1 AND gws2 > gws3 THEN gws2
ELSE gws3 END AS [Result(Max)]
FROM wtmon2

__TR__ 12-Feb-13 3:33am

You are welcome!

Max Value of Rows in SQL Server-2008

1 solution

Solution 1

Add your solution here

Preview 0

Max Value of Rows in SQL Server-2008

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us