Substitute for 'TOP' keyword

From: Ale Frisman <afrisman_at_retailexpert.com>
Date: 5 Apr 2004 12:38:12 -0700
Message-ID: <1f9b247d.0404051138.43707f96_at_posting.google.com>

Hi to all
[Quoted] [Quoted] 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

Alex Frisman Received on Mon Apr 05 2004 - 21:38:12 CEST