13,407,694 members (47,669 online)
See more:
Hi all,

I want to find out maximum value in a row. So, Iam using unpivot to find out the max value but it is giving an error. Can any one please help me. Thanks in advance.

```CREATE TABLE MAXVALUE
(
ID INT IDENTITY,
A INT,
B INT,
C INT
)```

this is myquery :

```SELECT MAX(VAL) AS MAXVALUE_ROW FROM
(SELECT *FROM MAXVALUE UNPIVOT
(Id for [max(val)] IN
([A],[B],[C])
))```

Error:

Msg 102, Level 15, State 1, Line 5
Incorrect syntax near ')'.
Posted 27-Dec-12 19:51pm
Updated 28-Dec-12 1:58am
v4
Sandeep Mewara 28-Dec-12 4:24am

bapu_reddy 28-Dec-12 4:54am

Msg 102, Level 15, State 1, Line 5
Incorrect syntax near ')'.
Aarti Meswania 28-Dec-12 5:17am

can you give some input output records?

## Solution 2

hi , sorry to say i don't have time to give solution for your post , i have one sample code .
please have a look on this

UNPIVOT:
-------
Used to convert columns into rows

```Create table tbl_stdmarksdata  (studentname nvarchar(100), I int, II int, III int, IV int, V int)
go

Insert into tbl_stdmarksdata (studentname,I,II,III,IV,V)
Select 'Vivek Johari',30,20,35, 40, 45
Union All
Select 'Chandra Singh',30,20,35,44, 80
Union All
Select 'Avinash Dubey',30,25,35,20, 39
Union All
Select 'Pankaj Kumar',33,29,30, 60, 50
go

select * from tbl_stdmarksdata
go
from tbl_stdmarksdata
unpivot
(Marks for Grade in (I,II,III,IV,V) ) as tblunpvt```

## Solution 1

try this...

```select id,COL,VAL from
(
SELECT Row_Number() over(order by val desc) as srno, id,COL,VAL
FROM
(SELECT * FROM MAXVALUE ) as p
UNPIVOT
(VAL for COL IN ([A],[B],[C])) as b
) as t where srno=1```

Happy Coding!
:)

Top Experts
Last 24hrsThis month
 OriginalGriff 413 ppolymorphe 298 phil.o 225 RickZeeland 190 Maciej Los 180
 OriginalGriff 5,960 Maciej Los 3,340 Richard MacCutchan 2,081 CPallini 1,945 F-ES Sitecore 1,435