I have this statement that works perfectly fine in Access and MSSQL: (In
words, i first get the top 50 id values according to the where clause and
then i get the maximum of those id values)
SELECT Max(id) FROM (select top 50 id from myTable where infoId in
( 3 ) AND id 100 order by id ASC) AS
I have this statement that works perfectly fine in Access and MSSQL: (In
words, i first get the top 50 id values according to the where clause and
then i get the maximum of those id values)
SELECT Max(id) FROM (select top 50 id from systemevents where infoId in
( 3 ) AND id 100 order by id
-
From: Catalin PLACINTA [EMAIL PROTECTED]
To: Wajih-ur-Rehman [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, September 22, 2003 2:33 PM
Subject: Re: plz help
Use the LIMIT clause in mysql instead of TOP clause for access and mssql.
Luck !
- Original Message -
From: Wajih-ur-Rehman