Board index » delphi » How emulate MySQL LIMIT clause in Oracle / SQL-Server

Frank. C.

Delphi Developer
Sun, 12 Dec 2004 03:37:10 GMT

How emulate MySQL LIMIT clause in Oracle / SQL-Server

How do I emulate the MySQL LIMIT clause (SELECT ... LIMIT 10,20) in oracle /
sql-server?

Frank

 
Eric Hil

Delphi Developer
Sun, 12 Dec 2004 10:48:10 GMT

Re:How emulate MySQL LIMIT clause in Oracle / SQL-Server


Oracle:
select * from (subquery) where rownum between 10 and 20;

Quote
"Frank. C." <gche...@nospam.hotmail.com> wrote in message

news:3d18c539_2@dnews...
Quote
> How do I emulate the MySQL LIMIT clause (SELECT ... LIMIT 10,20) in oracle
/
> sql-server?

> Frank

Frank C

Delphi Developer
Mon, 13 Dec 2004 09:36:21 GMT

Re:How emulate MySQL LIMIT clause in Oracle / SQL-Server


Any idea for SQL-Server?

Quote
> Oracle:
> select * from (subquery) where rownum between 10 and 20;

> "Frank. C." <gche...@nospam.hotmail.com> wrote in message
> news:3d18c539_2@dnews...
> > How do I emulate the MySQL LIMIT clause (SELECT ... LIMIT 10,20) in
oracle
> /
> > sql-server?

> > Frank

Wayne Niddery [TeamB

Delphi Developer
Mon, 13 Dec 2004 11:25:05 GMT

Re:How emulate MySQL LIMIT clause in Oracle / SQL-Server


Quote
"Frank C." <gche...@nospam.hotmail.com> wrote in message

news:3d1a6c36_2@dnews...

Quote
> Any idea for SQL-Server?

I beleive MSSQL supports TOP nn

--
Wayne Niddery (Logic Fundamentals, Inc.)
RADBooks: http://www.logicfundamentals.com/RADBooks/delphibooks.html
Those who disdain wealth as a worthy goal for an individual or a society
seem not to realize that wealth is the only thing that can prevent
poverty. - Thomas Sowell

Eric Hil

Delphi Developer
Tue, 14 Dec 2004 12:22:19 GMT

Re:How emulate MySQL LIMIT clause in Oracle / SQL-Server


To fully answer Frank's question, you'll probably need a subquery to limit
the results to not include the top 10 if you want 10 through 20:

select top 20 * from some_table where table_key not in (select top 10 key
from some_table)

Eric

Other Threads

1. LIMIT for MySQL limited to 37

2. Oracle SQL Help: "not in" clause

3. SQL Server: column_alias not allowed in WHERE clause

4. Access97, Oracle, SQL Server, Interbase Server or what?????

5. How to link Oracle server from SQL server 7.0

6. How to link Oracle server from SQL server 7.0

7. MySQL Memo Fields Returned (D5e, BDE5.11, MySQL on Linux Server, MyODBC)

8. SQL Server Databases (SQLServer,Oracle,DB/2

9. convert this sql (sql server) to oracle

10. Delphi and SQL server limit