Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

looking for the oracle equivalent of T-SQL 'SELECT TOP n'

61918Nov 13 2001

Hi,
I'm looking for the Oracle equivalent of T-SQL 'SELECT TOP n'
and can't find any. There is SAMPLE(n) function but it supposed
to pick up random values and I'm not sure if it's possible to
make it select top values. Please help 8-)
Thanx

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 25 2002

Added on Nov 13 2001

#database-and-application-migrations

3 comments

342 views