Token line number = 1,Token line offset = 56,Token in error = select

I'm getting following error while retrieving value from S开发者_如何转开发QL Server Ce:

Token line number = 1,Token line offset = 56,Token in error = select

Where my query is:-

select columnName 
from TableName 
where PrimaryKey=(select max (PrimaryKey) from TableName);

Please suggest to me the possible errors.

The database might not support that type of subquery. Try it without a subquery:

select top 1 columnName 
from TableName
order by PrimaryKey desc