Pivot function and Missing expression error
select * from (
select T.PAT_MRN_ID, T.ABBREVIATION,CONCEPT_VALUE from TBL_WORKLFOw T
)
pivot
(
max(concept_value)
for ABBREVIATION in (select ABBREVIATION from TBL_WORKLFOW )
)
this query is throwing "missing expression"..error.
Can some one help figuring out the problem.