Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Ultimate Question: Oracle, MSSQL, Others vs MYSQL LIMIT Statement

Re: Ultimate Question: Oracle, MSSQL, Others vs MYSQL LIMIT Statement

From: Marshall Spight <mspight_at_dnai.com>
Date: Tue, 17 Sep 2002 03:36:33 GMT
Message-ID: <5rxh9.1479$L12.228@sccrnsc02> 





"LLCeder" <llceder_at_wxs.nl> wrote in message news:am5tbs$lb9$1_at_reader12.wxs.nl...


>

> In Oracle you would use a statement like :

>

> SELECT username FROM

>                               (SELECT username

>                                  FROM users_table

>                                ORDER BY username)

>  WHERE  rownum BETWEEN 1 AND 10

>

> But I think it's safe to say that it will not be as efficient as the LIMIT

> clause in MySQL.




Why? I'd imagine they look very much the same internally.




Marshall
Received on Mon Sep 16 2002 - 22:36:33 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US