Board index » delphi » Oracle 8 Syntax Question (vs. MS SQL)

Brent William

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Oracle 8 Syntax Question (vs. MS SQL)

Hi All,
 In MS SQL I can say "Select Top 10 * From Table"

Is there an equivalent in Oracle?  I know it does not support the Top
predicate but is their another way?

Thanks,
 Brent

 
Arthur E.F.Heinric

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Oracle 8 Syntax Question (vs. MS SQL)


select * from table where rownum <= 10

[]s
Arthur

Brent Williams <bwilli...@netmerchants.net> escreveu nas notcias de
mensagem:8qb5va$q...@bornews.borland.com...

Quote
> Hi All,
>  In MS SQL I can say "Select Top 10 * From Table"

> Is there an equivalent in Oracle?  I know it does not support the Top
> predicate but is their another way?

> Thanks,
>  Brent

Lars Blac

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Oracle 8 Syntax Question (vs. MS SQL)


Quote
> select * from table where rownum <= 10

Note that this only work (correct) for unordred selects. The RowNum (which
is like a hidden field) is assigned BEFORE ordering..

Cheers,
Lars

Other Threads

1. SQL Syntax: Oracle vs. MSSQL

2. BCD vs Integer in Oracle and MS SQL

3. Q - SQL / D2 / Paradox Tables / SQL Syntax question!!

4. SQL Databases - MS Sql Server 7 vs. Interbase

5. MS SQL Server - ODBC vs SQL Links

6. MS SQL vs. BDE SQL

7. MS SQL 6.5 vs Local SQL Query

8. MS SQL 6.0 timedate field problem with syntax

9. Problem with MS SQL server syntax

10. Interbase vs. MySQL vs MS SQL Server vs Oracle