Michael,
I do not believe there is a real equivalent. SQL Server supports the
'TOP' statement. It is like using the one-argument variation of
MySQL's LIMIT clause. It looks like:
SELECT TOP 20 foo FROM BAR
The obvious problem is that this is pretty much useless for
pagination, sin
Well, I am not sure about MS, but in Oracle you have to use the rownum
pseudocolumn and a pseudocolumn, an example:
SELECT * FROM (SELECT * FROM mytable ORDER BY somedatefield) WHERE rownum >
20 AND rownum < 30;
or something like that. It may be similar for MSsql, I am not sure.
Mike
P.S. my e
Hi,
I don't know MSSQL well, but what about TOP ?
Regards,
Jocelyn
- Original Message -
From: "Michael Marano" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 15, 2002 10:37 PM
Subject: LIMITing result sets - Spoiled by MySQL
I am used to working in MySQL, and am n