[ Home  |  FAQ-Related Q&As  |  General Q&As  |  Answered Questions ]

    Search the Q&A Archives

...get top record in Sybase. Iam not able to use ...

<< Back to: Sybase FAQ: 9/19 - ASE Admin (6 of 7)

Question by Veena
Submitted on 7/22/2004
Related FAQ: Sybase FAQ: 9/19 - ASE Admin (6 of 7)
Rating: Rate this question: Vote
How do i get top record in Sybase.
Iam not able to use
select top 10 * from mytable
go


Answer by Mark
Submitted on 9/6/2004
Rating: Not yet rated Rate this answer: Vote
use the following:
select min(strName) from...

 

Answer by SybaseRowCount
Submitted on 12/21/2004
Rating: Not yet rated Rate this answer: Vote
SET ROWCOUNT 10

SELECT * FROM MYTABLE

 

Answer by angel
Submitted on 12/1/2005
Rating: Not yet rated Rate this answer: Vote
Hi, I need that information too, so please answer :)

 

Answer by Alistair Cook
Submitted on 1/27/2006
Rating: Not yet rated Rate this answer: Vote
Set rowcount 10
select top 10 * from mytable
go

 

Answer by d5keg@hotmail.com
Submitted on 4/17/2006
Rating: Not yet rated Rate this answer: Vote
I am looking for something like this as well.

 

Answer by Chili
Submitted on 8/30/2006
Rating: Not yet rated Rate this answer: Vote
set rowcount 5
select * from table
set rowcount 0

 

Answer by Lorenzosjb
Submitted on 12/11/2006
Rating: Not yet rated Rate this answer: Vote
Is pretty simple. Put this in a single sql statement:

set rowcount 10; select top 10 * from mytable

regards,
Lorenzo Jimenez

 

Answer by Lorenzosjb
Submitted on 12/11/2006
Rating: Not yet rated Rate this answer: Vote
Is pretty simple. Put this in a single sql statement:

set rowcount 10; select * from mytable

regards,
Lorenzo Jimenez

 

Answer by zero
Submitted on 3/12/2007
Rating: Not yet rated Rate this answer: Vote
You can Use SET ROWCOUNT ##

Example:

SET ROWCOUNT 10

SELECT * FROM TABLE

This is the equivalent to

SELECT TOP 10 * FROM TABLE

 

Answer by Gothike
Submitted on 4/17/2007
Rating: Not yet rated Rate this answer: Vote
SET ROWCOUNT 5
select * from table
order by field
SET ROWCOUNT 0

you can change the row count to the top you want... and don't forget to always finish the rowcount in 0, or all your queries will top in 5 or the quantity you put there.

Regards.
Adrian

 

Your answer will be published for anyone to see and rate.  Your answer will not be displayed immediately.  If you'd like to get expert points and benefit from positive ratings, please create a new account or login into an existing account below.


Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer:

FAQS.ORG reserves the right to edit your answer as to improve its clarity.  By submitting your answer you authorize FAQS.ORG to publish your answer on the WWW without any restrictions. You agree to hold harmless and indemnify FAQS.ORG against any claims, costs, or damages resulting from publishing your answer.

 

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

 

<< Back to: Sybase FAQ: 9/19 - ASE Admin (6 of 7)

[ Home  |  FAQ-Related Q&As  |  General Q&As  |  Answered Questions ]
© 2008 FAQS.ORG. All rights reserved.