jaysonhill03
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.