Allan, Mark <Mark.Allan-g5UQV3DIpT5Wk0Htik3J/[EMAIL PROTECTED]> wrote:
Select Top <n> * From PATIENTS WHERE PATIENT_PK NOT IN (SELECT TOP
<n> PATIENT_PK From PATIENTS Order By PATIENT_PK) Order By PATIENT_PK
It would appear that the "TOP" syntax is not supported by SQLite
(maybe just a Microsoft thing?).
SQLite supports LIMIT and OFFSET clauses. To select <n> rows starting
from <m>th one (it appears that's what you are doing), do
SELECT PATIENT_PK From PATIENTS Order By PATIENT_PK LIMIT <n> OFFSET
<m>;
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
