newbie: Limit rows returned in a select
This is a discussion on newbie: Limit rows returned in a select within the Sybase forums, part of the Database Server Software category; --> Is there a way to limit the number of rows returned in a select statement? I thought it was ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-08-2008, 03:52 PM
| |||
| |||
 Re: newbie: Limit rows returned in a select On Thu, 28 Aug 2003 06:42:55 -0700, Alison wrote: > Is there a way to limit the number of rows returned in a select statement? > > I thought it was TOP(5) but that does not work.. Look up the "SET ROWCOUNT xxx" command in the ASE reference manual. Michael -- Michael Peppler Data Migrations, Inc. mpeppler@peppler.org http://www.mbay.net/~mpeppler Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or long term contract positions - http://www.mbay.net/~mpeppler/resume.html      |
|
04-08-2008, 03:52 PM
| ||||
| ||||
| Re: newbie: Limit rows returned in a select In article <41a170d2.0308280542.72430ca4@posting.google.com >, alison.craine@atsc.army.mil says... > >Is there a way to limit the number of rows returned in a select statement? > >I thought it was TOP(5) but that does not work.. in ASA it's select top 5 * from table klint. |
 |
« Re: problems with output parameters with Ole Db provider for ASE 12.5
|
Re: Newbie: Script question... Urgent - deadline due!! »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 08:24 AM.
