Home » RDBMS Server » Server Administration » TOP & ROWCOUNT
TOP & ROWCOUNT [message #375265] Wed, 15 August 2001 16:19 Go to next message
jwk
Messages: 2
Registered: August 2001
Junior Member
Hello.
In MSSQL, the number of rows of a select query can be limited to 100 by either:
SELECT TOP 100 * FROM Table1
or
SET ROWCOUNT = 100
SELECT * FROM vwTable1View

How can this be done in Oracle SQL?

Thank you for your time and assistance.

JWK

Report message to a moderator

Re: TOP & ROWCOUNT [message #375266 is a reply to message #375265] Wed, 15 August 2001 17:04 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
select * from table where rownum<100

Report message to a moderator

Re: TOP & ROWCOUNT [message #375267 is a reply to message #375266] Wed, 15 August 2001 19:37 Go to previous message
jwk
Messages: 2
Registered: August 2001
Junior Member
You da man.
Thank you.
jwk

Report message to a moderator

Previous Topic: Search for fields in Multiple tables
Next Topic: Re: How to convert Strign value TO_NUMBER
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 24 10:27:59 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.