SQL Mobile - invalid TOP function?

helly guys

i am trying to run this sql but it seems that the TOP is not available

MySQL
SELECT * FROM table WHERE A_Index > 10 LIMIT 0, 8

MSSQL
SELECT 5 * FROM table WHERE A_Index

so what about sqlmobile?..can't seem to get the sql working..is there other alternatives?

Thanks