TOP operator question

Posted on 2004-11-05
Last Modified: 2009-12-16
I know this is a beginner question, but I am a beginner.
I am running SYBASE 12 on Solaris 8, and there doesn't seem to be a TOP operator. I run the query below, and get the error on the bottom

1> select TOP 1 lease
2> from tmp_mults
3> go
Msg 102, Level 15, State 1:
Server 'smc', Line 1:
Incorrect syntax near '1'.

My question is, if there is no TOP operator within SYBASE (on Solaris), is there a way to replicate?

Thanks in advance to whoever helps this newbie.
Question by:jaysonhill03
    1 Comment
    LVL 10

    Accepted Solution

    Yes, you can use the



    use "set rowcount 0" to go back to all rows.

    TOP itself is supported starting with the 12.5.3 release (CR340399).

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now