Link to home
Create AccountLog in
Avatar of ASPDEV
ASPDEV

asked on

Top N rows in SQL CE 2.0

Hello Experts,

I have a Production issue, where I need to get Top 100 rows from 10k records in the Table.Where I tried TOP,LIMIT,.. and many but SQL CE 2.0 doesn't support TOP in SQL Query.

Thanks,
ASPDEV.
ASKER CERTIFIED SOLUTION
Avatar of ralmada
ralmada
Flag of Canada image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of ASPDEV
ASPDEV

ASKER

Thanks.