Sql Help

Databases
1

What would be the ODBC(MS-ACCESS) equivalent of the following MYSQL statement?

"SELECT * FROM TABLE LIMIT 10, 19 ";

Please Help…I would really apprecaite it.

Thanks,
-Parash-

2

You can use TOP instead of LIMIT, but not with an offset as far as I am aware.

3

Thanks…could you please tell me how to get rid of the offset problem…I want the offset for the pagination purpose…I know there must some way to tackle this issue…I would really appreciate if you could provide me with some logic…

Thanks in advance

4

using TOP or LIMIT without an ORDER BY clause makes no sense

5

Hi, I need some help with SQL and date fields.
What format should I use to query a date/hour field? say I want all records where the date is after a given date.
Is there any way to access the current day? maybe using VBscript
Can I subtract two dates?

Thanks,

Pablo

6

DATETIME

yes, the special CURRENT_DATE keyword

yes, with a datetime function, which varies from one database system to another, e.g. DATEDIFF – consult your manual