SQL CE 3.5 and the ‘SELECT TOP’ Query

Finally! SQL CE 3.5 now supports the ‘TOP’ keyword. However, there is a trick to this: you must surround the number with parenthesis.

For example, in regular T-SQL you would write

SELECT TOP N [col] FROM [table]

However, in SQL CE 3.5 you must write

SELECT TOP (N) [col] FROM [table]