I get SYNTAX ERROR 1064 with mySQL 3.2.3 when using delete as sho wn

[Jawad Khan]

Hope you can find the problem in the following SQL command:

delete from alarms where raiseTime = ( select MIN(raiseTime) from alarms)
limit 1 ;

raiseTime is of type BIGINT.