set rowcount using subquerys

I have a subquery under sybase included into a select statement, an example..

select name from (select * from table1, table2, where...)

I know that using "set rowcount" I can limit rows from the main select statement, but I want to restrict rows in the inner select statement,

This is a result of migrating from sql server 2000 to sybase, please help me before I get completely crazy.
fgm0Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
namasi_navaretnamConnect With a Mentor Commented:
Try something like this: Sybase does not support TOP keyword.

Set Rowcount 100

select *
into #temp
from table1, table2, where...

select name from #temp

regards-
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.