How to find the maximum number in the table

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Hi,

Please find the below sql server - total table.

Col 1 Col 2 Col 3 Col 4
1 5 6 8
11 14 18 12

i want to out put of maximum number in the total table.

Posted 14-Mar-15 1:13am

Raghu425

Add a Solution

Comments

CHill60 14-Mar-15 7:21am

Do you mean the maximum value across all columns? What have you tried so far?

Raghu425 14-Mar-15 7:28am

Hi,
yes i want maximum number acrross all columns,pls. help me on this.

2 solutions

Add a Solution

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

OriginalGriff · Accepted Answer · 2015-03-14T01:32:00

Solution 1

Use UNPIVOT:

SQL

SELECT MAX(vx) FROM MyTable AS a
UNPIVOT (vx FOR Value IN (Col1, Col2, Col3, Col4)) AS up

[edit]Typo: missed "AS a"[/edit]

Posted 14-Mar-15 1:32am

OriginalGriff

Updated 14-Mar-15 1:33am

v2

Comments

Maciej Los 14-Mar-15 9:46am

+5!

Maciej Los · Accepted Answer · 2015-03-14T03:46:00

Solution1 by OriginalGriff[^] is very good. As an alternative, check this:

SQL

SELECT MAX(A.MyValue)
FROM (
    SELECT Col1 AS MyValue
    FROM TableName 
    UNION ALL
    SELECT Col2 AS MyValue
    FROM TableName 
    UNION ALL
    SELECT Col3 AS MyValue
    FROM TableName 
    UNION ALL
    SELECT Col4 AS MyValue
    FROM TableName 
) AS A

How to find the maximum number in the table

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How to find the maximum number in the table

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us