[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 547
  • Last Modified:

TOP operator question

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.
0
jaysonhill03
Asked:
jaysonhill03
1 Solution
 
bretCommented:
Yes, you can use the

SET ROWCOUNT <n>

command

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

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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now