Re: Substitute for 'TOP' keyword

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 6 Apr 2004 10:28:42 +0100
Message-ID: <4072784a$0$3301$ed9e5944_at_reading.news.pipex.net>

"Ale Frisman" <afrisman_at_retailexpert.com> wrote in message news:1f9b247d.0404051138.43707f96_at_posting.google.com...
> Hi to all
> I'm using TOP keyword in SQL Server sql statement which returns a
> specifid number of rows : "SELECT TOP 2 * from TABLE_NAME" =>
> returns first 2 rows
>
> Does anybody knows or used a simiular technique in Oracle?
> Any help greatly appreciated

http://www.jlcomp.demon.co.uk/faq/top_sql.html

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Tue Apr 06 2004 - 11:28:42 CEST

This message: [ Message body ]
Next message: Pyromancer: "Re: Web Single Sign-On"
Previous message: Brian Peasland: "Re: Oracle Apache"
In reply to: Ale Frisman: "Substitute for 'TOP' keyword"
In reply to Ale Frisman: "Substitute for 'TOP' keyword"
Next in thread: Pyromancer: "Re: Web Single Sign-On"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message